Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How does Auto Flush table works?

Rick54
Tera Expert

Hi,

Can someone help me with the job/process which handles the auto-flush table? I have increased the records age in auto-flush table then trying to find a job which executes the process to test but I am unable find anything. I appreciate if someone can give me more insight into this. Thanks!

1 ACCEPTED SOLUTION

Check out this:

find_real_file.png

Please mark as Correct Answer and Helpful, if applicable.
Thank You!
Abhishek Gardade

Thank you,
Abhishek Gardade

View solution in original post

8 REPLIES 8

Allen Andreas
Tera Patron

Hi,

This is usually handled by a scheduled job, have you looked through those?

System Definition > Scheduled Jobs

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Thanks for the response Allen. I tried with table name but no luck.

Hi,

The actual scheduled job that invokes the Table Cleaner (sys_auto_flush) runs every hour.

https://<yourinstance.service-now.com/sys_trigger.do?sys_id=a1de683dc0a8010a008419cd3659cf8f&sysparm_record_target=sys_trigger&sysparm_record_row=1&sysparm_record_rows=1&sysparm_record_list=next_actionONToday%40javascript%3Ags.daysAgoStart%280%29%40javascript%3Ags.daysAgoEnd%280%29%5EnameSTARTSWITHTable+Cleaner%5EORDERBYDESCsys_updated_on

Regards,

Nithish

AbhishekGardade
Giga Sage

Hello  Rick,

The actual scheduled job that invokes the Table Cleaner (sys_auto_flush) runs every hour.
Also there is a job called BulkTableCleaner

Please mark as Correct Answer and Helpful, if applicable.
Thank You!
Abhishek Gardade

Thank you,
Abhishek Gardade