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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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"
}

Photo of Ramesh

Ramesh

  • 518 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
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