m (1 revision imported: Adding Chat Thread tables for Iteration 14) |
(Deleting dummy line) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
= View ADMIN_ETL_JOB_HISTORY = | = View ADMIN_ETL_JOB_HISTORY = | ||
| − | + | ||
| − | + | <onlyinclude> | |
| − | |||
{{PDMView | {{PDMView | ||
|viewName = ADMIN_ETL_JOB_HISTORY | |viewName = ADMIN_ETL_JOB_HISTORY | ||
| Line 8: | Line 7: | ||
|viewDesc = 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. | |viewDesc = 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. | ||
|introduced = | |introduced = | ||
| − | |SQL = | + | |SQL = <source lang="xml" enclose="div">select |
JOB_ID, | JOB_ID, | ||
JOB_NAME, | JOB_NAME, | ||
| Line 24: | Line 23: | ||
JOB_NAME, | JOB_NAME, | ||
JOB_VERSION | JOB_VERSION | ||
| − | + | </source> | |
| − | |||
}} | }} | ||
| Line 62: | Line 60: | ||
|colDesc = The status of the step, such as COMPLETE or FAILED. | |colDesc = The status of the step, such as COMPLETE or FAILED. | ||
}} | }} | ||
| − | + | </onlyinclude> | |
| − | + | ||
| − | + | [[Category:V:GIM:8.5DRAFT]] | |
Latest revision as of 13:38, January 7, 2020
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. |
References
The summary List of References will include the following entries for this table or view:
There are no references from this table/view.
This page was last edited on January 7, 2020, at 13:38.
Comments or questions about this documentation? Contact us for support!