Table CTL_ETL_HISTORY
In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
- DV = Default value
- For Microsoft SQL Server, varchar/nvarchar in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in cloud deployments is not multi-language.) THIS BULLET WILL DISPLAY ONLY IN THE PE MSSQL PDM.
Contents
Description
This table provides information about the execution of each Genesys Info Mart job. A row is added to this table after each job completes.
Column List
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
JOB_ID | varchar(64) | X | X | ||
WORKFLOW_TYPE | varchar(32) | X | X | ||
JOB_NAME | varchar(32) | ||||
JOB_VERSION | varchar(32) | ||||
LOCAL_START_TIME | timestamp(3) | ||||
LOCAL_END_TIME | timestamp(3) | ||||
GMT_START_TIME | timestamp(3) | ||||
GMT_END_TIME | timestamp(3) | ||||
DURATION | integer | ||||
STATUS | varchar(32) | ||||
CREATED_TS | integer | X |
JOB_ID
ID that uniquely identifies the execution instance of the job.
WORKFLOW_TYPE
The name of the step of the job, such as Outbound.
JOB_NAME
The name of the job, such as Job_ExtractICON.
JOB_VERSION
The version of the job, such as 8.1.000.10.
LOCAL_START_TIME
The date and time the first step of the job started (in the time zone where Genesys Info Mart Server is running).
Note: Because the Genesys Info Mart Server always runs in the GMT time zone, the value of this field is always the same as GMT_START_TIME.
LOCAL_END_TIME
The date and time the last step of the job ended (in the time zone where Genesys Info Mart Server is running).
Note: Because the Genesys Info Mart Server always runs in the GMT time zone, the value of this field is always the same as GMT_END_TIME.
GMT_START_TIME
The date and time the first step of the job started (in GMT time zone).
GMT_END_TIME
The date and time the last step of the job ended (in GMT time zone).
DURATION
The duration of the job, in seconds.
STATUS
The status of the job, such as COMPLETE or FAILED.
CREATED_TS
The UTC-equivalent value of the date and time at which the job started.
Index List
CODE | U | C | Description |
---|---|---|---|
I_C_ETL_H_CTS | Improves purge performance. |
Index I_C_ETL_H_CTS
Field | Sort | Comment |
---|---|---|
CREATED_TS | Ascending |
Subject Areas
References
The summary List of References will include the following entries for this table or view:
There are no references from this table/view.