Schedule the ETL

The ETL Scheduler tab lets you schedule the Incremental ETL process to run and update the data mart.

Note:

Updating reports table must always be followed by an update to the CASE_MASTER.LAST_UPDATE_TIME. (Updating the CASE_MASTER will result in moving the case along with all the reports to the mart schema.)

To schedule the ETL:

1. Click Tools on the global toolbar.

   The ADMINISTRATION TOOLS page appears.

2. Click the ETL Scheduler tab.

   Note:

   This is Oracle Argus Insight ETL only and will not populate the Oracle Argus Mart database. For instructions on how to run Oracle Argus Mart ETL, refer to the Oracle Argus Mart Installation and Administration Guide.

3. Define how often you want to run the ETL by selecting one of the following options:
   • Hourly every so many hours, starting at a specific time
   • Daily at a specific time
   • Weekly at a specific time on a set day of the week
   • Monthly on a set day of the month at a specific time
4. Specify the other parameters, such as the hour of the day when the ETL will run. Use the 24-hour format (HH:MM:SS) when specifying a time value.
5. Click Save Schedule to save the settings.

To run the ETL immediately, click Run ETL Now. Running the ETL immediately does not affect the scheduled ETL.