Jump to: navigation, search
(Resaving again after removing only whitespace to refresh the Cargo table)
(Adding a dummy line and resaving to refresh the Cargo table)
Line 1: Line 1:
 
= View ADMIN_ETL_JOB_HISTORY =
 
= View ADMIN_ETL_JOB_HISTORY =
 +
 +
dummy line
 
    
 
    
 
<onlyinclude>  
 
<onlyinclude>  
Line 7: Line 9:
 
|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 = <source lang="xml" enclose="div">select
+
|SQL = <source lang="xml" enclose="div">select
 
JOB_ID,
 
JOB_ID,
 
JOB_NAME,
 
JOB_NAME,
Line 61: Line 63:
 
}}
 
}}
 
</onlyinclude>
 
</onlyinclude>
 +
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 13:38, January 7, 2020

View ADMIN_ETL_JOB_HISTORY

dummy line




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.

Comments or questions about this documentation? Contact us for support!