How to modify the default execution time of Table cleaner

[Shirley7]

dear all,

Regarding table cleaner, I see this on document: Table cleaner is a scheduled job that runs once per hour (by default) to delete older, expired, or unwanted records from tables.

I would like to know if this default execution time can be modified?

And if the answer is yes, how to do?

Thank you!

[Community Alums · Accepted solution]

HI Shirley,

Yes, that's possible!!

Navigate to "sys_trigger.LIST"

Search for "Table Cleaner" and open the record , Scroll down and change the desired time in "Repeat" field:

Update.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Sagar Pagar]

Hi,

The Table Cleaner is a scheduled job runs the table cleaner every hour be default. You can change it, but before modify it. Please go through this kb -

Information Regarding Table Cleaner

For a particular table the job will delete the records for 1200 seconds on a particular run, and once it crosses this 1200 seconds the job will stop the deletion for the particular table and will resume for this table in next run.

Thanks,

Sagar Pagar