Schedule a Database Maintenance Action

Use the Scheduler's Database Maintenance Action to perform selected database maintenance operations on a scheduled basis. When you schedule a Database Maintenance Action, you define which database maintenance operations to perform:

• Full-Text Search maintenance: Rebuilding Full-Text Search catalog.
• Index maintenance: Rebuilding Indexes and shrinking SQL logs.
• Queue and User account maintenance: Refreshing Queue status and removing unused User accounts.

Good to know:

• Weekly database maintenance is recommended.
• Schedule your database maintenance operations for after business hours because it can interrupt performance. For example, rebuilding the SQL Server Full-Text catalog will prevent Users from doing Full-Text searches while the catalog is rebuilding.
• Database maintenance requires re-indexing database tables.
• For more information about database maintenance, refer to Perform Database System Maintenance.

To schedule a Database Maintenance Action:

1. Open the Scheduler.

   To open the Scheduler window:

   1. In the CSM Administrator main window, click the Scheduling category, and then click the Edit Schedule task.
2. Click the Add button.

   The Schedule Item Properties window opens.

3. Click the Action page.
4. In the Action drop-down, select Database maintenance.

   

5. Define Full-text Search options:
   • Rebuild Full-Text Search catalog: Select this check box to rebuild the Full-Text Search catalog when the database maintenance action is run. CSM uses Full-Text Search for Quick Search and Knowledge Search. If you have problems with your index getting corrupted, you might want to rebuild the search catalog once a week or every night.
6. Select which indexes to rebuild:
   • Rebuild Business Object indexes: Select this check box to rebuild Business Object indexes when the database maintenance action is run. This option allows you to rebuild the indexes of the database tables that represent particular Business Objects. Then, click the Select button to select which Business Objects to re-index.

     Note: By default, all Business Objects are selected. Uncheck Business Objects to exclude them from reindexing, or select Clear All to uncheck all Business Objects, and then select the ones you want to re-index.

   • If you have a high volume of data, you might want to rebuild your table indexes monthly.
   • Rebuild system table indexes: Select this check box to rebuild the indexes of the SQL Server tables associated with CSM system tables when the database maintenance action is run. These tables start with "Trebuchet" (the internal code name for the product). If you have a high volume of data, you might want to rebuild your table indexes monthly.
   • Shrink SQL event log: Select this check box to shrink the SQL Server event log file when the database maintenance action is run.

     IMPORTANT: Consult with your Administrator before scheduling this option. If in doubt, do not use this feature unless you run into problems.

7. Define data options:
   • Refresh Queue status: Select this check box to refresh Queue status when the database maintenance action is run. Queue status can get out of sync if Business Objects that were on Queues are deleted. This option ensures that each Queue is synchronized. We recommend scheduling this weekly.
   • Refresh unused user accounts: Select this check box to remove data associated with deleted User accounts when the database maintenance action is run. When User accounts are deleted from the system, their authorization information might not be removed. This option ensures that the authorization information is in sync with the User list by removing the unused information. We recommend scheduling this weekly.
8. Click OK.