ETL Status Report

The ETL Status report provides information about the status of the ETL main sequence which is the information about the synchronization of data from the Contract Management Database to the Reporting Database.

Report Details

This report consists of the following details:

The ETL Start Time - Start time of data synchronization from the Contract Management database to the Reporting Database.
ETL End Time - End time of data synchronization from the Contract Management database to the Reporting Database.
Status - Consolidated status of all synchronized jobs
- If the time taken for the job is less than 2 hours, the status is displayed as Running.
- If the status of the previous job is Aborted and a new ETL main sequence has started, the status is displayed as Running.
- If there is no End Job time, the status is displayed as Failure.
- If the time taken for the job is greater than 2 hours, the status is displayed as Contact your Datastage Administrator.
- When the End Job time is recorded, the status is displayed as Success.