This window allows you to specify when SQL Compliance Manager should perform maintenance tasks on the Repository, such as rebuilding indexes in the event and archive databases. Because these tasks can be resource-intensive and require extra disk space, consider specifying a time period with slow activity.
Each day, during the specified time, SQL CM continues to execute the required maintenance tasks on any event databases or attached archive database that has not yet been maintained, until all databases are maintained. These tasks are performed as background processes during the allotted time period.
You can view the status of your databases on the Databases tab of the Configure Repository Databases window. You can also choose to manually update a database.
TIP |
Specify a duration time that is larger than the Collection Server heartbeat interval. By default, the Collection Server heartbeat is five minutes. |