Managing analytics jobs

Setting the retention times for the database tables

See also

Analytics Log dialog for information on viewing the log of the last run of the Analytics jobs

NOTE: We recommend running the "analyze statistics" process on Oracle systems periodically. This is especially important after a substantial data change, such as after running the Enterprise Cleanup.

Opening the Analytics Jobs dialog

You use the Analytics Job dialog to set retention times for the Enterprise Cleanup and to schedule the Analytics Load job. To open this dialog, locate the System Configuration tasks in the Action pane's Configuration panel and click Manage analytics jobs.

Setting the retention times for the database tables

On the Retention tab of the Analytics Jobs dialog, you set the retention time (i.e., the number of days data is retained) for each of the tables in the Enterprise database. This retention time defines how long data will be retained in a given table before being cleaned up.

There is no one "recipe" for how to set the number of retention days. It will all depend on the usage profile of the QIDM system as deployed in your organization. Although a default "age of data" value (in days) will have already been entered for each table, you can change – and in fact should change – the times to meet your requirements. Be sure to study the Best Practice in Analytics Jobs dialog.

Scheduling the Analytics Load process

On the Schedule tab of the Analytics Jobs dialog, edit this predefined schedule.

By default, the predefined schedule is disabled. You will need to enable it to have it take effect.

NOTE: The Enterprise Cleanup process is run automatically after the Analytics Load process, so there is no need to schedule it separately.

To edit and enable the schedule

Set the recurrence settings and start time as needed.
Clear the Disabled check box to enable the schedule.
Click Save to save your changes, and then click Close to close the dialog.