How do you execute the Cleanup Agent after retiring a record?

As I’ve understood, to “Retire” a record doesn’t (permanently) delete the record from the database. The (permanent) “Delete” operation will be executed by the Cleanup Agent. (It seems that the Cleanup Agent is used to clean up the DC jobs. I’m not sure if it is the same agent for deleting the records.) But I can’t find the configuration for the frequency of the Cleanup Agent. Also, can we execute the cleanup operation immediately from the Admin Console? Thanks in advance for your help.

Retiring a record will not mark the record as deleted, and hence, will not be cleaned up by the Cleanup Agent. The record needs to be deleted for the Cleanup Agent to pick it up and (permanently) delete it from the database. The Cleanup Agent, apart from other cleanup, cleans up all the records marked for deletion, which were deleted 24 hours or more. There is no other agent to clean the deleted records. The Cleanup Agent will run only once a day. You can specify the time at which you want to start the Cleanup Agent. The property is called CLEAN_HOUR and is specified in your The Cleanup task can be executed from the Admin Console too. If you navigate to Database Manager > Database Admin Task, you will find the different cleanup processes you can perform.

If your goal is to delete the record immediately, there is a way to force the Cleanup Agent to delete records that are only minutes old. You can add the property CLEANUP_AGENT_RECORD_DATA_AGE=2 to your and restart the server. Once the Cleanup Agent is run from the Admin Console, records that are older than 2 minutes will be permanently deleted. This is especially useful when you perform a data load and need to delete the data to run it a second time.

[Admin: This post is related to the 07.08.15 post about manually running the Cleanup Agent.]

Continue reading


6 thoughts on “How do you execute the Cleanup Agent after retiring a record?

  1. Pingback: How do you unretire and return records to a null state in bulk? | TRIRIGAFEEDIA

  2. Pingback: How do you manually run the Cleanup Agent? | TRIRIGAFEEDIA

  3. Pingback: How do you set the Cleanup Agent frequency to every “x” records? | TRIRIGAFEEDIA

  4. Pingback: How do you set the Cleanup Agent to clean data “x” days or older? | TRIRIGAFEEDIA

  5. Pingback: Why can’t the Cleanup Agent clean large number of records? | TRIRIGAFEEDIA

  6. Pingback: How do you avoid the tree error after deleting hierarchy records? | TRIRIGAFEEDIA

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s