Enterprise Administration Guide › Administering CA ControlMinder Enterprise Management › Audit Data › Clean Up Submitted Tasks

Clean Up Submitted Tasks

CA ControlMinder Enterprise Management stores audit data, including SAM audit data, in the central database. However, database performance may be affected if you store a large amount of audit data in the central database. To improve the database performance, you can use the Cleanup Submitted Tasks wizard to remove submitted tasks from the central database.

Important! Cleaning up submitted tasks deletes audit data from the database. To avoid data loss, we recommend that you route audit events to CA User Activity Reporting before you run the cleanup task.

You can schedule the cleanup task to run immediately or at recurring intervals. Cleaning up submitted tasks consumes a large amount of system resources. We recommend that you schedule this task outside business hours.

Follow these steps:

1. In CA ControlMinder Enterprise Management, click System, Tasks, Cleanup Submitted Tasks.

   The Cleanup Submitted Tasks: Recurrence page appears.

2. Perform one of the following tasks:
   • To run the task immediately, select Execute now and click Next.

     The Cleanup Submitted Tasks: Cleanup Submitted Tasks page appears. Skip to step 4.

   • To create a recurring schedule, select Schedule new job and complete the fields that appear. The following fields are not self-explanatory:

     Time Zone

     Specifies the time zone of the Enterprise Management Server.

     If you are in a different time zone to the server, you can select either your time zone or the server time zone when you schedule a new job. You cannot change the time zone when you modify an existing job.

     Weekly Schedule

     Specifies that the task runs at a specific time on a specific day or days of the week.

     Specify the time in 24-hour format, for example, 17:15.

     Advanced Schedule

     Lets you use a cron expression to specify the times at which the task runs.

3. Click Next.

   The Cleanup Submitted Tasks: Cleanup Submitted Tasks page appears.

4. Complete the following fields:
   • Minimum Age
   • Archive

     Specifies to backup tasks to the archive database before deleting the tasks from the runtime database.

   • Audit Timeout
   • Time Limit
   • Task Limit
   • Delete per transaction
5. Click Finish.

   CA ControlMinder Enterprise Management removes submitted tasks from the central database at the time that you specified.