TDM Cleanup Process
The TDMDB_CleanUp job is defined in the TDM LU. Its purpose is to clean up old inactive records from the TDM DB.
The list of TDM tables to be cleaned-up and deleted is taken from the TDMCleanup MTable object. The cleanup process gets all the records whose cleanup_ind field is TRUE, and it runs the Delete statement on each table.
The following cleanup parameters are defined in tdm_general_parameters:
- cleanup_retention_period - the number of months of the retention period of inactive records. The cleanup process deletes inactive records that are older than the retention period. By default, this value is set to 0.25, i.e., all inactive records updated over a week ago are deleted from the TDM DB by the cleanup process.
Update this parameter to set a different retention period.
How do I Run the TDM Cleanup Process?
By default, the TDMDB_CleanUp job is scheduled to run automatically every 7 days in the TDM Jobs table. You can set it to run manually or set a different time interval for an automatic execution.
Click for more information about the Jobs table.
TDM Cleanup Process
The TDMDB_CleanUp job is defined in the TDM LU. Its purpose is to clean up old inactive records from the TDM DB.
The list of TDM tables to be cleaned-up and deleted is taken from the TDMCleanup MTable object. The cleanup process gets all the records whose cleanup_ind field is TRUE, and it runs the Delete statement on each table.
The following cleanup parameters are defined in tdm_general_parameters:
- cleanup_retention_period - the number of months of the retention period of inactive records. The cleanup process deletes inactive records that are older than the retention period. By default, this value is set to 0.25, i.e., all inactive records updated over a week ago are deleted from the TDM DB by the cleanup process.
Update this parameter to set a different retention period.
How do I Run the TDM Cleanup Process?
By default, the TDMDB_CleanUp job is scheduled to run automatically every 7 days in the TDM Jobs table. You can set it to run manually or set a different time interval for an automatic execution.
Click for more information about the Jobs table.
