System Table Cleanup
The System Table Cleanup function provides an automated mechanism for clearing data from high volume transactional tables that do not need to track data indefinitely.
To update/create:
Field name | Description | Example |
|---|---|---|
Name | Name of the table cleanup configuration | System log record cleanup |
Table | Table whose records will be deleted beyond the maximum retention period of record’s “Date field” + “Maximum age in seconds” | SystemLogRecord |
Date field | Field on the Table that is used as the start of the data retention period calculation | CreatedOn |
Active | If the cleanup configuration is active | Yes |
Maximum age in seconds | For every record in the table specified in the “Table” field, this is the maximum elapsed period (in seconds) from the date/time specified in the nominated “Date field”, before the record is automatically deleted. | 604800 seconds (7 days) |