Configuring maintenance options

Use the Maintenance Configuration section of the page Settings > Reporting > Log Database to control certain aspects of database processing, such as the time for running the database maintenance job, some of the maintenance tasks performed, and deletion of database partitions and error logs.

Steps

  1. For Maintenance start time, select the time of day for running the database maintenance job. Default value is 1:00.
    The time and system resources required by this job vary depending on the tasks you select in this area. To minimize any impact on other activities and systems, it is best to run this job during a slow email traffic period.
  2. Mark the check box Automatically delete a partition with an end date older than, and then specify the number of days (from 1 to 365) after which partitions should be deleted (default is 365).
    Warning: After a partition has been deleted, the data cannot be recovered. See Enabling database partitions for an alternative way to delete partitions.
  3. Mark the check box Enable automatic reindexing of partitions on, and then select a day of the week to have this processing performed automatically (default is Saturday).

    Reindexing the database is important to maintain database integrity and to optimize reporting speed.

    Important: It is best to perform this processing during a quiet time for email traffic. Reindexing database partitions is resource intensive and time consuming. Reports should not be run during the reindexing process.
  4. Mark the check box Delete failed batches after and then enter a number of days (from 1 to 365) after which to delete any failed batches. Default value is 20.

    If this option is not checked, failed batches are retained indefinitely for future processing.

    If there is insufficient disk space or inadequate database permissions to insert log records into the database, the records are marked as a failed batch. Typically, these batches are successfully reprocessed and inserted into the database during the nightly database maintenance job.

    However, this reprocessing cannot be successful if the disk space or permission problem is not resolved. Additionally, if the Process any unprocessed batches option is not selected, failed batches are never reprocessed. They are deleted after the time specified here.

  5. Mark the check box Process any unprocessed batches to have the nightly database maintenance job reprocess any failed batches.
    If this option is not checked, failed batches are never reprocessed. They are deleted after the time specified in step 4, if any.
  6. Mark the check box Delete the log after, and then enter a number of days (1 to 120) after which to delete database error records. Default value is 45.
    If this option is not checked, error logs are retained indefinitely.
  7. Click OK to activate changes to the maintenance configuration options.