Scheduling Database Cleanup Tasks

You can schedule the Transaction History Purge Utility to run using the Windows Control Panel.

To schedule tasks, use the Control Panel to open Scheduled Tasks. Then add a scheduled task for the Transaction History Purge Utility and follow the instructions in the Scheduled Task Wizard. Make sure to view advanced properties on the last screen of the wizard.

When you view the properties for the scheduled task, you can add parameters at the end of the Run text box. For example, if you add parameters to the end of the string in the Run text box, it may show: database_cleanup_utility.exe -u<user> -p<password> -a20 -np, which deletes all applicable transactions older than 20 days without any prompts.

The exit codes and logging capabilities are useful when using Windows Scheduler, since you do not need to be logged in when it runs, and if it fails you can view a log to determine the cause. You can find the log file, Database_Cleanup_Utility_Log.txt, in <EPM_ORACLE_INSTANCE>\logs\epma.