Question 1:
What is the time stamp format displayed in the JOB Status API. I am able to see the time stamp in EDT format in the Delphix GUI but in the JOB Status REST API, it is showing as GMT + 1 format.
Question: 2:
Why the timestamp having T and Z.
Example:
timestamp : 2016-05-09T18:02:11.729Z
updateTime : 2016-05-09T18:09:16.690Z
{ "action" : null,
"job" : null,
"result" : { "actionType" : "DB_PROVISION",
"cancelable" : true,
"emailAddresses" : null,
"events" : [ { "messageAction" : null,
"messageCode" : "event.job.started",
"messageCommandOutput" : null,
"messageDetails" : "DB_PROVISION job started for \"TDM/TEST123\".",
"messageText" : "DB_PROVISION job started for \"TDM/TEST123\".",
"percentComplete" : 0.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:11.729Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.provision.starting",
"messageCommandOutput" : null,
"messageDetails" : "Starting provision of the virtual database \"TEST123\".",
"messageText" : "Starting provision of the virtual database \"TEST123\".",
"percentComplete" : 0.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:11.922Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.create.timeflow",
"messageCommandOutput" : null,
"messageDetails" : "Creating new TimeFlow.",
"messageText" : "Creating new TimeFlow.",
"percentComplete" : 0.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:11.944Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.generate.scripts",
"messageCommandOutput" : null,
"messageDetails" : "Generating recovery scripts.",
"messageText" : "Generating recovery scripts.",
"percentComplete" : 3.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:13.230Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.storage.export",
"messageCommandOutput" : null,
"messageDetails" : "Exporting storage.",
"messageText" : "Exporting storage.",
"percentComplete" : 6.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:13.383Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.mount",
"messageCommandOutput" : null,
"messageDetails" : "Mounting filesystems for the virtual database instance \"1\".",
"messageText" : "Mounting filesystems for the virtual database instance \"1\".",
"percentComplete" : 9.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:15.590Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.mount_source_archive",
"messageCommandOutput" : null,
"messageDetails" : "Mounting read-only archive log filesystem for the virtual database instance \"1\".",
"messageText" : "Mounting read-only archive log filesystem for the virtual database instance \"1\".",
"percentComplete" : 10.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:27.184Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oracledb.oracle.recovering",
"messageCommandOutput" : null,
"messageDetails" : "Recovering Oracle database.",
"messageText" : "Recovering Oracle database.",
"percentComplete" : 45.0,
"state" : null,
"timestamp" : "2016-05-09T18:02:31.638Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.opening.database",
"messageCommandOutput" : null,
"messageDetails" : "Opening the virtual database \"TEST123\".",
"messageText" : "Opening the virtual database \"TEST123\".",
"percentComplete" : 45.0,
"state" : null,
"timestamp" : "2016-05-09T18:05:04.334Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oracledb.oracle.opening",
"messageCommandOutput" : null,
"messageDetails" : "Opening Oracle database.",
"messageText" : "Opening Oracle database.",
"percentComplete" : 51.0,
"state" : null,
"timestamp" : "2016-05-09T18:05:05.936Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.recovery.success",
"messageCommandOutput" : null,
"messageDetails" : "Oracle recovery was successful.",
"messageText" : "Oracle recovery was successful.",
"percentComplete" : 51.0,
"state" : null,
"timestamp" : "2016-05-09T18:07:49.052Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.unmount_source_archive",
"messageCommandOutput" : null,
"messageDetails" : "Unmounting read-only archive log filesystem for the virtual database instance \"1\".",
"messageText" : "Unmounting read-only archive log filesystem for the virtual database instance \"1\".",
"percentComplete" : 51.0,
"state" : null,
"timestamp" : "2016-05-09T18:07:49.079Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.provision.success",
"messageCommandOutput" : null,
"messageDetails" : "The virtual database \"TEST123\" was successfully provisioned.",
"messageText" : "The virtual database \"TEST123\" was successfully provisioned.",
"percentComplete" : 60.0,
"state" : null,
"timestamp" : "2016-05-09T18:07:53.577Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.update.redologs.generate.scripts",
"messageCommandOutput" : null,
"messageDetails" : "Generate scripts for adding new online redo log files to virtual database \"TEST123\".",
"messageText" : "Generate scripts for adding new online redo log files to virtual database \"TEST123\".",
"percentComplete" : 69.0,
"state" : null,
"timestamp" : "2016-05-09T18:08:41.730Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.update.redologs.push.scripts",
"messageCommandOutput" : null,
"messageDetails" : "Push scripts for adding new online redo log files to virtual database \"TEST123\".",
"messageText" : "Push scripts for adding new online redo log files to virtual database \"TEST123\".",
"percentComplete" : 71.0,
"state" : null,
"timestamp" : "2016-05-09T18:08:41.826Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.jobs.oraclevdb.update.redologs",
"messageCommandOutput" : null,
"messageDetails" : "Add new online redo log files to virtual database \"TEST123\".",
"messageText" : "Add new online redo log files to virtual database \"TEST123\".",
"percentComplete" : 71.0,
"state" : null,
"timestamp" : "2016-05-09T18:08:42.593Z",
"type" : "JobEvent"
},
{ "messageAction" : null,
"messageCode" : "event.job.completed",
"messageCommandOutput" : null,
"messageDetails" : "DB_PROVISION job for \"TDM/TEST123\" completed successfully.",
"messageText" : "DB_PROVISION job for \"TDM/TEST123\" completed successfully.",
"percentComplete" : 100.0,
"state" : null,
"timestamp" : "2016-05-09T18:09:16.727Z",
"type" : "JobEvent"
}
],
"jobState" : "COMPLETED",
"name" : null,
"namespace" : null,
"parentAction" : "ACTION-5958",
"parentActionState" : "COMPLETED",
"percentComplete" : 100.0,
"reference" : "JOB-3129",
"startTime" : "2016-05-09T18:02:11.686Z",
"suspendable" : false,
"target" : "ORACLE_DB_CONTAINER-189",
"targetName" : "TDM/TEST123",
"targetObjectType" : "OracleDatabaseContainer",
"title" : "Provision virtual database \"TEST123\".",
"type" : "Job",
"updateTime" : "2016-05-09T18:09:16.690Z",
"user" : "USER-2"
},
"status" : "OK"
}
#DemoEnvironment#Tip