Jump to: navigation, search

View ADMIN_EXTRACT_HISTORY

Description

This view provides information about the data that is extracted from each source database table. A row is added to this view after Job_ExtractICON successfully completes extracting a source data table. 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.
DBCONNECTION The name of the Database Access Point (DAP) through which data was extracted.
ICON_DBID ID that uniquely identifies the ICON application instance. Applies only to tables extracted by Job_ExtractICON.
TABLE_NAME The name of the table from which data is extracted.
LATEST_DATA_TIME Provides the highest timestamp value for the records that are extracted in a given extraction cycle.
ROW_COUNT Provides the number of records that are extracted in a given extraction cycle.

SQL Query

select
JOB_ID,
JOB_NAME,
JOB_VERSION,
EXTRACT_START_TIME as START_TIME,
EXTRACT_END_TIME as END_TIME,
DATEDIFF(SECOND,EXTRACT_START_TIME,EXTRACT_END_TIME) as DURATION,
DAP_NAME as DBCONNECTION,
ICON_DBID,
TABLE_NAME,
MAX_TS as LATEST_DATA_TIME,
ROW_COUNT
from
CTL_EXTRACT_HISTORY

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 14:55.