| Line 1: | Line 1: | ||
| − | = View ADMIN_EXTRACT_HISTORY= | + | = View ADMIN_EXTRACT_HISTORY = |
| + | |||
| + | <onlyinclude> | ||
| + | |||
| + | {{PDMView | ||
| + | |viewName = ADMIN_EXTRACT_HISTORY | ||
| + | |shortDesc = | ||
| + | |viewDesc = | ||
| + | |introduced = | ||
| + | |SQL = <source lang="xml" enclose="div">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 | ||
| + | |||
| + | </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 = 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 = DBCONNECTION | |colName = DBCONNECTION | ||
| − | |colDesc = The name of the Database Access Point (DAP) through which data was extracted. | + | |colDesc = The name of the Database Access Point (DAP) through which data was extracted. |
}} | }} | ||
{{PDMViewColumn | {{PDMViewColumn | ||
|colName = ICON_DBID | |colName = ICON_DBID | ||
| − | |colDesc =ID that uniquely identifies the ICON application instance. Applies only to tables extracted by Job_ExtractICON. | + | |colDesc = ID that uniquely identifies the ICON application instance. Applies only to tables extracted by Job_ExtractICON. |
}} | }} | ||
{{PDMViewColumn | {{PDMViewColumn | ||
| − | |colName =TABLE_NAME | + | |colName = TABLE_NAME |
| − | |colDesc =The name of the table from which data is extracted. | + | |colDesc = The name of the table from which data is extracted. |
}} | }} | ||
{{PDMViewColumn | {{PDMViewColumn | ||
| − | |colName =LATEST_DATA_TIME | + | |colName = LATEST_DATA_TIME |
| − | |colDesc =Provides the highest timestamp value for the records that are extracted in a given extraction cycle. | + | |colDesc = Provides the highest timestamp value for the records that are extracted in a given extraction cycle. |
}} | }} | ||
{{PDMViewColumn | {{PDMViewColumn | ||
| − | |colName =ROW_COUNT | + | |colName = ROW_COUNT |
|colDesc =Provides the number of records that are extracted in a given extraction cycle. | |colDesc =Provides the number of records that are extracted in a given extraction cycle. | ||
}} | }} | ||
| + | |||
| + | </onlyinclude> | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] | ||
Revision as of 15:00, May 9, 2016
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. |
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!