Activate table cleanup

Activate table cleanup for tables with older, expired, or unwanted records.

Before you begin

Role required: admin

Procedure

1. Open the Auto Flush [sys_auto_flush] table by typing sys_auto_flush.list in the filter navigator and select New.
2. Fill in the fields on the form.

   Table 1. Auto Flush form

   Field	Description`
   Tablename	The name of the target table.
   Matchfield	The Date/Time field in the target table that is used to monitor duration. Defaults to sys_created_on, which deletes records based on the amount of time since their creation date.
   Age in seconds	The amount of time the system waits before deleting records. When the Matchfield value becomes older than the Age in seconds, the record is deleted.
   Active	Option to activate or deactivate table cleaning for this table.
   Application	The application scope to which this table cleaner job applies.
   Clean peripheral	If selected, related records in the Journal Entry [sys_journal_field] table are also deleted. If cleared, the system deletes records from the target table, but not any related journal records in this tables.
   Clean audit	If selected, related records in these audit tables are also deleted: Sys Audit [sys_audit] table Audit Relationship Change [sys_audit_relation] table Note that the audit records that are created by table cleaner in the Audit Deleted Record [sys_audit_delete] table are preserved. If cleared, the system deletes records from the target table, but not any related audit records in these tables.
   Cascade delete	If selected, this option deletes all matching records plus any records referring to them. If cleared, the system deletes matching records, but not records referring to them.
   Conditions	Condition builder for specifying filter conditions that define the records to be removed.

3. Select Submit.

Result

Table cleaner runs automatically and deletes records when they meet the specified record age and any conditions that you set for them.