| Line 1: | Line 1: | ||
= View ADMIN_ETL_JOB_STATUS = | = View ADMIN_ETL_JOB_STATUS = | ||
| − | + | ||
| − | <onlyinclude> | + | <onlyinclude> |
| − | + | ||
| − | {{PDMView | + | {{PDMView |
| − | |viewName = ADMIN_ETL_JOB_STATUS | + | |viewName = ADMIN_ETL_JOB_STATUS |
| − | |shortDesc = | + | |shortDesc = |
| − | |viewDesc = 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. | + | |viewDesc = 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. |
| − | |introduced = | + | |introduced = |
| − | |SQL = <source lang="xml" enclose="div">select | + | |SQL = <source lang="xml" enclose="div">select |
| − | MAX(JOB_ID) as JOB_ID, | + | MAX(JOB_ID) as JOB_ID, |
| − | JOB_NAME, | + | JOB_NAME, |
| − | MAX(JOB_VERSION) as JOB_VERSION, | + | MAX(JOB_VERSION) as JOB_VERSION, |
| − | MIN(START_TIME) as START_TIME, | + | MIN(START_TIME) as START_TIME, |
| − | CASE | + | CASE |
| − | WHEN MIN(START_TIME) < MAX(END_TIME) | + | WHEN MIN(START_TIME) < MAX(END_TIME) |
| − | THEN MAX(END_TIME) | + | THEN MAX(END_TIME) |
| − | ELSE NULL | + | ELSE NULL |
| − | END as END_TIME, | + | END as END_TIME, |
| − | CASE | + | CASE |
| − | WHEN MIN(START_TIME) < MAX(END_TIME) | + | WHEN MIN(START_TIME) < MAX(END_TIME) |
| − | THEN DATEDIFF(SECOND,MIN(START_TIME),MAX(END_TIME)) | + | THEN DATEDIFF(SECOND,MIN(START_TIME),MAX(END_TIME)) |
| − | ELSE NULL | + | ELSE NULL |
| − | END as DURATION, | + | END as DURATION, |
| − | MAX(STATUS) as STATUS | + | MAX(STATUS) as STATUS |
| − | from | + | from |
| − | CTL_WORKFLOW_STATUS | + | CTL_WORKFLOW_STATUS |
| − | where | + | where |
| − | STATUS NOT IN ('NOT_CONFIGURED','INSTALLED') | + | STATUS NOT IN ('NOT_CONFIGURED','INSTALLED') |
| − | AND JOB_ID in (select MAX(JOB_ID) from CTL_WORKFLOW_STATUS group by JOB_NAME) | + | AND JOB_ID in (select MAX(JOB_ID) from CTL_WORKFLOW_STATUS group by JOB_NAME) |
| − | group by | + | group by |
| − | JOB_NAME | + | JOB_NAME |
| − | + | </source> | |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = JOB_ID | + | |colName = JOB_ID |
| − | |colDesc = ID that uniquely identifies the execution instance of the job. | + | |colDesc = ID that uniquely identifies the execution instance of the job. |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = JOB_NAME | + | |colName = JOB_NAME |
| − | |colDesc = The name of the job, such as Job_ExtractICON. | + | |colDesc = The name of the job, such as Job_ExtractICON. |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = JOB_VERSION | + | |colName = JOB_VERSION |
| − | |colDesc = The version of the job, such as 8.1.000.10. | + | |colDesc = The version of the job, such as 8.1.000.10. |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = START_TIME | + | |colName = START_TIME |
| − | |colDesc = The date and time at which the first step started (UTC time zone). | + | |colDesc = The date and time at which the first step started (UTC time zone). |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = END_TIME | + | |colName = END_TIME |
| − | |colDesc = The date and time at which the last step ended (UTC time zone). | + | |colDesc = The date and time at which the last step ended (UTC time zone). |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = DURATION | + | |colName = DURATION |
| − | |colDesc = The duration of the job, in seconds. | + | |colDesc = The duration of the job, in seconds. |
| − | }} | + | }} |
| − | + | ||
| − | {{PDMViewColumn | + | {{PDMViewColumn |
| − | |colName = STATUS | + | |colName = STATUS |
| − | |colDesc = The status of the step, such as COMPLETE or FAILED. | + | |colDesc = The status of the step, such as COMPLETE or FAILED. |
| − | }} | + | }} |
| − | + | ||
| − | </onlyinclude> | + | </onlyinclude> |
| − | + | ||
| − | [[Category:V:GIM:8.5DRAFT]] | + | [[Category:V:GIM:8.5DRAFT]] |
Revision as of 13:25, August 18, 2016
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. |
References
The summary List of References will include the following entries for this table or view:
There are no references from this table/view.
Comments or questions about this documentation? Contact us for support!