API/Python/Open-Source Solutions

Expand all | Collapse all

what is the time format displayed in the JOB Status API?

Jump to Best Answer
  • 1.  what is the time format displayed in the JOB Status API?

    Posted 05-20-2016 10:09:00 AM

    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


  • 2.  RE: what is the time format displayed in the JOB Status API?
    Best Answer

    Posted 05-20-2016 10:34:00 AM
    Hi,

    Delphix Engine is using a GMT time internally and API calls return always time using a GMT timezone. If you want to display it with using a Delphix Engine timezone, you need to do this conversion on client side.

    Time is formatted using a ISO 8601 format - https://en.wikipedia.org/wiki/ISO_8601

    regards
    Marcin