Define Database Maintenance Action Options

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. Database maintenance requires re-indexing database tables.
Queue and User account maintenance: Refreshing Queue status and removing unused User accounts.
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. For more information about database maintenance, refer to Perform Database System Maintenance.

To define a Database Maintenance Action:


Full-text Search	Rebuild Full-Text Search catalog: 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.
Manage Indexes	Rebuild Business Object indexes: 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: 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: 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.
Data	Refresh Queue status: 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. Remove unused user accounts: 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. Synchronize Team Info with team list: Synchronizes the Team Info Lookup table with CSM User and Customer Team list.