Jump to: navigation, search
m (1 revision imported: Adding Chat Thread tables for Iteration 14)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
= View ADMIN_ETL_STEP_HISTORY =
 
= View ADMIN_ETL_STEP_HISTORY =
−
 
+
 
−
  <onlyinclude>
+
<onlyinclude>
−
 
+
 
−
  {{PDMView
+
{{PDMView
−
  |viewName = ADMIN_ETL_STEP_HISTORY
+
|viewName = ADMIN_ETL_STEP_HISTORY
−
  |shortDesc =  
+
|shortDesc =  
−
  |viewDesc = This view provides information about the execution of each ETL job step. Rows are added to this view for completed ETL job steps only. As each ETL job completes, it adds rows for the completed steps of all currently running ETL jobs, including itself, that have not already been added to the view.  
+
|viewDesc = This view provides information about the execution of each ETL job step. Rows are added to this view for completed ETL job steps only. As each ETL job completes, it adds rows for the completed steps of all currently running ETL jobs, including itself, that have not already been added to the view.  
−
 
+
 
−
  Currently running ETL jobs may have steps that are in process or are waiting, and they do not yet appear in the view. Rows in this view are written once and are not updated.
+
Currently running ETL jobs may have steps that are in process or are waiting, and they do not yet appear in the 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,
−
  WORKFLOW_TYPE,
+
WORKFLOW_TYPE,
−
  JOB_VERSION,
+
JOB_VERSION,
−
  MIN(LOCAL_START_TIME) AS START_TIME,
+
MIN(LOCAL_START_TIME) AS START_TIME,
−
  MAX(LOCAL_END_TIME)  AS END_TIME,
+
MAX(LOCAL_END_TIME)  AS END_TIME,
−
  SUM(DURATION)        AS DURATION,
+
SUM(DURATION)        AS DURATION,
−
  MAX(STATUS)          AS STATUS
+
MAX(STATUS)          AS STATUS
−
  from
+
from
−
  CTL_ETL_HISTORY
+
CTL_ETL_HISTORY
−
  where
+
where
−
  JOB_ID NOT IN (SELECT JOB_ID FROM CTL_ETL_HISTORY WHERE STATUS in ('RUNNING'))
+
JOB_ID NOT IN (SELECT JOB_ID FROM CTL_ETL_HISTORY WHERE STATUS in ('RUNNING'))
−
  group by
+
group by
−
  JOB_ID,
+
JOB_ID,
−
  JOB_NAME,
+
JOB_NAME,
−
  WORKFLOW_TYPE,
+
WORKFLOW_TYPE,
−
  JOB_VERSION
+
JOB_VERSION
−
 
+
 
−
  </source>
+
</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 = WORKFLOW_TYPE
+
|colName = WORKFLOW_TYPE
−
  |colDesc = The name of the ETL job step, such as Outbound.
+
|colDesc = The name of the ETL job step, such as Outbound.
−
  }}
+
}}
−
 
+
 
−
  {{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]]

Latest revision as of 22:59, June 6, 2019

View ADMIN_ETL_STEP_HISTORY

Description

This view provides information about the execution of each ETL job step. Rows are added to this view for completed ETL job steps only. As each ETL job completes, it adds rows for the completed steps of all currently running ETL jobs, including itself, that have not already been added to the view.

Currently running ETL jobs may have steps that are in process or are waiting, and they do not yet appear in the 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.
WORKFLOW_TYPE The name of the ETL job step, such as Outbound.
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 June 6, 2019, at 22:59.
Comments or questions about this documentation? Contact us for support!