AX1432

Scheduler tasks for database maintenance

Scheduler provides several built-in tasks that are intended for database maintenance. By default, these tasks are included in the System.IndexMaintenance job, which runs regularly to maintain your database. However, these tasks can also be added manually to jobs as needed to perform additional database maintenance.

The following database maintenance tasks are available:

• Rebuild Database Indexes task
• Update Database Statistics task
• Update Indexes and Constraints task

All of these tasks are predefined versions of the Execute SQL Command task. You can use the Source Axiom Database field to specify whether the task is executed against the system database or the audit database.

For the SQL Command Text, the actual SQL code used by each task is generated automatically by Axiom Software when the task is executed. This ensures that the tasks always use the most current SQL code for each task as defined by Axiom Software.