Cleaning Up the Database Log Table

You can remove old and out-of-date logging entries in the async job or data feed history tables to save disk space and reduce the number of records to search if you are troubleshooting.

Specify settings for database log table cleanup

  1. Go to the Database Log Table Cleanup section for the instance.

    1. Start the Archer Control Panel.
    2. From the Instance Management list, double-click the instance for which you want to enable the database log table cleanup.
    3. On the General tab, go to the Database Log Table Cleanup section.
  2. In the first Retention Period (days) field, enter the number of retention period days for the Async Job Table. This defines the number of days for which the table retains its entries.

    3. Note: You cannot disable the Async Job Table option.

  3. In Data Feed History Table, select the option to enable cleanup of aged data feed executions as well as associated warnings and error messages.
  4. In the second Retention Period (days) field, enter the number of retention period days for the Data Feed History Table.

    5. Note: This field determines the number of days the Review Job Queues page in Archer retains information. For more information, see "Reviewing Job Queues" in the Archer Platform Help.

  5. On the toolbar, click Save.