Contents

View ADMIN_ETL_JOB_HISTORY

Description

This view provides information about the execution of each ETL job. A row is added to this view after each ETL job completes. Currently running ETL jobs do not appear in this view. Rows in this view are written once and are not updated.

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.

SQL Query

selectJOB_ID,JOB_NAME,JOB_VERSION,MIN(GMT_START_TIME) AS START_TIME,MAX(GMT_END_TIME) AS END_TIME,DATEDIFF(SECOND,MIN(GMT_START_TIME),MAX(GMT_END_TIME)) AS DURATION,MAX(STATUS) AS STATUSfromCTL_ETL_HISTORYwhereJOB_ID NOT IN (SELECT JOB_ID FROM CTL_WORKFLOW_STATUS WHERE STATUS in ('RUNNING'))group byJOB_ID,JOB_NAME,JOB_VERSION