| Line 6: | Line 6: | ||
|viewName = ADMIN_ETL_JOB_STATUS | |viewName = ADMIN_ETL_JOB_STATUS | ||
|shortDesc = | |shortDesc = | ||
| − | |viewDesc = | + | |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 | ||
Revision as of 22:11, August 4, 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!