View ADMIN_ETL_JOB_STATUS

Description

This view provides information about the most recent execution of each ETL job. A row is added to this view after each ETL job starts and is updated as the job status changes.

Column List

Column	Description
JOB_ID	ID that uniquely identifies the execution instance of the job.
JOB_NAME	The name of the job, such as Job_ExtractICON.
JOB_VERSION	The version of the job, such as 8.1.000.10.
START_TIME	The date and time at which the first step started (UTC time zone).
END_TIME	The date and time at which the last step ended (UTC time zone).
DURATION	The duration of the job, in seconds.
STATUS	The status of the step, such as COMPLETE or FAILED.