Which schedule job perform table cleaner task ?

[harshw]

Hi all,

We have  a requirement to delete records based on condition . Count of records to delete are around 4million so we have used table cleaner for this purpose and created an autoflush record . But i want to know which scheduled job is executing the table cleaner task . I would like to execute it manual or atleast know the frequency of execution so that i can be sure when will next table cleaner run.  Where can i find these details in my instance.

Thanks in advance!

@madhavm @Community Alums @isaak_papagiann 

[JP - Kyndryl]

Hi,

You will find "Table Cleaner" in the sys_trigger table,  so do   sys_trigger.list  to get the list of system schedules.

As you will see, the cleaner is run every hour.

[Community Alums]

Hi @harshw ,

The name of the Schedule job is "Table Cleaner".

Please check to know more: https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/managing-data/concep...

[Saurav11]

Hello,

There is this nice article f you want to understand things in detail:-

https://www.servicenow.com/community/now-platform-articles/demystifying-table-rotation-extension-and...

[Mark Roethof]

Hi there,

JP - Kyndryl already gave the correct answer. Just want to add, if this is a first time deletion with millions of records, you might want to optimize the table. This will benefit performance, reduce the database footprint, etc..

You can do this yourself (by changing the force_optimize field) or involve ServiceNow Support.

Kind regards,
Mark