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
- In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.
This table provides information about the execution of each Genesys Info Mart job. A row is added to this table after each job completes.
Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.
ID that uniquely identifies the execution instance of the job.
The name of the step of the job, such as Outbound.
The name of the job, such as Job_ExtractICON.
The version of the job, such as 8.1.000.10.
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.
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.
The date and time the first step of the job started (in GMT time zone).
The date and time the last step of the job ended (in GMT time zone).
The duration of the job, in seconds.
The status of the job, such as COMPLETE or FAILED.
The UTC-equivalent value of the date and time at which the job started.
|I_C_ETL_H_CTS||Improves purge performance.|
No subject area information available.