Define Purge System Table Action Options
Use the Scheduler's Purge System Table Action to purge CSM system table email records and attachments on a scheduled basis.
Good to know:
- This Action physically deletes the selected items from the database. Prior to scheduling this Action you should backup any items that you need to retain for future use.
- It is recommended that you schedule this Action to run out of normal business hours as it may take some time to complete, especially for larger purges.
- For on-premise customers that want to reclaim disk space after purging, a DBA will need to run SQL Server's DB shrink command.
To define a Purge System Table Action:
- In the CSM Administrator main window, select the Scheduling category, and then select the Edit Schedule task.
- Add or edit a Scheduled Item that uses a Purge System Table Action, and then select the Action page.
- Provide the following settings as they apply:
Option Description Table
Email: Select this option to purge email records. Journal - Mail History records recording details about the email will remain, but trying to drill into the actual linked email will result in a "not found" message.
Attachments: Select this option to purge attachments from the Trebuchet attachment table.- Attachments and their links to the Business Object are removed.
- Purging will honor the attachment audit settings for any Business Object; a journal entry will indicate the attachment was removed.
Business Object Selection (attachments only)
Select the Business Objects from which file attachments (and links) will be removed. Date Filter
Older Than: Select this option to purge email or attachments older than the number of Years, Months or Days you specify.
Time Range: Select this option to purge email or attachments for a date range you specify. Select the calendar buttons to specify the dates.
Estimate
Select to display an estimate of the number of emails or attachments that will be purged.