question Re: How Table Cleaner(scheduled job) works to execute sys_auto_flush records ? in ServiceNow AI Platform forum

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

Community Alums — Wed, 13 Oct 2021 06:04:30 GMT

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 ?

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

Maik Skoddow — Wed, 13 Oct 2021 07:02:00 GMT

Hi @abc

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

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.

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

Maik Skoddow — Tue, 19 Oct 2021 06:18:31 GMT

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

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

Community Alums — Tue, 19 Oct 2021 06:40:31 GMT

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.

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

Maik Skoddow — Tue, 19 Oct 2021 09:02:15 GMT

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.

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

Community Alums — Tue, 19 Oct 2021 10:36:55 GMT

hi @Maik Skoddow ,

No doubt Servicenow Team has well explained the table cleaner but I haven't got exact answer to my question.

Here's the thing, if you remember what I wanna know, is that considering there are multiple sys_auto_flush records that we are moving to higher instances at once with matching field and age in seconds as same for all records , in this Case I wanna know which table will be first picked up by table cleaner to delete the records ?

And there's one more thing I've mentioned as a question in that article ....

Suppose If we have any table( incident_task) which is dependent on another table( incident) as shown below .

And the Table cleaner picks up 'incident_task' first to delete the data, how will this work since 'Incident' records are not yet deleted and hence the condition will not be matched.

What will happen in this case ?

If you've answers to my question , kindly reply.

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

Maik Skoddow — Wed, 20 Oct 2021 05:11:56 GMT

Hi @abc

there is no guaranteed order in the selection of tables in case of equal conditions.

And regarding your second question:
A reference to the parent Incident record is just a string value. Therefore no technical dependencies exist and the incident_task records can be deleted without any problems.

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.

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

Community Alums — Wed, 20 Oct 2021 06:11:48 GMT

Okay one doubt is clear, there's no guaranteed order in table selection.

Just one more thing if you can confirm.

Be it any number of condition for a table(in a sys_auto_flush record), as Table Cleaner runs every hour it might take time((delete few records at one go) but will delete all records that matches the condition for each record configured in sys_auto_flush table.

Can you confirm if this is the case if we have dependency of more than one table on a table for which we have configured sys_auto_flush record ??

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

Maik Skoddow — Wed, 20 Oct 2021 10:20:22 GMT

Hi @abc

"Can you confirm if this is the case if we have dependency of more than one table on a table for which we have configured sys_auto_flush record ??"

sorry, but I don't understand this question. Two "if" in one sentence are irritating me!

But maybe I am not the right person to answer your questions as I did not build the table cleaner.

Kind regards
Maik