Define Database Maintenance Action Options

Use the Scheduler's Database maintenance Action to perform selected database maintenance operations on a scheduled basis.

Schedule database maintenance operations for after business hours because it can interrupt performance. For example, when you rebuild the SQL Server Full-Text catalog, it prevents users from doing full-text searches while the catalog is rebuilding.

Define the following settings as they apply, and then select Save.

Setting Description Notes
Full-text search Rebuild full-text search catalog: Rebuilds the full-text search catalog.

CSM uses full-text search for quick search and knowledge search. If your index gets corrupted, rebuild the search catalog once a week or every night.

Manage indexes Rebuild Business Object indexes: This option allows you to rebuild the indexes of the database tables that represent particular Business Objects. Select the Select button to select which Business Objects to reindex. By default, all Business Objects are selected. Clear Business Objects to exclude them from reindexing. Select Clear All to clear all Business Objects.

If you have a high volume of data, you may want to run this action monthly.

Rebuild system table indexes: Rebuilds the indexes of the SQL Server tables associated with CSM system tables. These tables start with "Trebuchet" (the internal code name for the product). If you have a high volume of data, you may want to run this action monthly.
Shrink SQL event log: Shrinks the SQL Server event log file.

Consult your administrator before you schedule this option. If in doubt, do not use this feature unless you run into problems.

Pull up SaaS indexes: Pulls up the SaaS indexes.  
Data Refresh queue status: Refreshes queue status. Queue status can unsync if Business Objects that were on queues are deleted. This option ensures that each queue syncs. We recommend you run this action weekly.
Remove unused user accounts: Remove data associated with deleted user accounts. When user accounts are deleted from the system, their authorization information may not be removed. This option ensures that the authorization information is in sync with the user list by removing the unused information. We recommend you run this action weekly.
Synchronize Team Info with team list: Synchronizes the Team Info Lookup table with CSM user and customer team lists.  
Delete Temporary Data: Deletes temporary data.  
Remove orphaned attachments: Removes any orphaned attachments.  
Fix mismatched definition IDs: Fixes any mismatched Def IDs.