How Table Cleaner(scheduled job) works to execute sys_auto_flush records ?

abc48
Kilo Contributor

Suppose I have a Incident and few tables are dependent on Incident like Incident Task and Customer. I wanna know if I have sys_auto_flush record created for all these tables with 'Age in Seconds' as 9 months for each, which table record will get deleted first and will all record be deleted at once for that table or it will pick few records for 1st iteration of deletion ?  How exactly will the Scheduled job(Table Cleaner) work ?

8 REPLIES 8

Maik Skoddow
Tera Patron
Tera Patron

Hi @abc 

please read article at https://community.servicenow.com/community?id=community_article&sys_id=f6578d61db502810fb115583ca961...

I suppose you will not get a better explanation on how the cleaner works as this article is from the ServiceNow platform team.

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

Hi @abc 

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If so, please mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik

abc48
Kilo Contributor

Thanks for the article @Maik Skoddow , but I still have some questions which I have posted in the link (https://community.servicenow.com/community?id=community_article&sys_id=f6578d61db502810fb115583ca961940) provided by you.

Looking forward to get answers on that.

 

Hi @abc 

did you see the answers at that article? 

I was pleasantly surprised to see that the ServiceNow team answered your questions quite detailed.

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.