How does sys_auto_flush table works in regards with timings/Repeat interval?

[Nivetha K1]

Hi All,

As per my understanding, "Table Cleaner" schedule with Job ID "BulkTableCleaner" present in schedule table will execute every one hour automatically and clear the entries based on the conditions written in Auto flush table.

In Scheduled job, we can specify the timing/repeat interval at when the each job should run. So, our jobs will run at different times and clear the entries.

Is there any way to run each entry in Auto Flush table with different timings as same as scheduled job?

Any help/insight regarding this would be much helpful.

Regards,

Nivetha.

[Akshata jamdar]

Hello Nivetha,

Please refer some links below,

https://community.servicenow.com/community?id=community_question&sys_id=b65247eddb98dbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=b847b412db7d00904819fb243996...

Hope this will help you to resolve your query.

Kindly mark the answer correct and helpful if it will resolved your query.

Regards,
Akshata
(ServiceNow Developer).

[Nivetha K1]

Hi Akshata,

Thanks for your response !

My query is about, defining each auto flush entry in different timings. The URL you provided doesn't explain about it.

I want to know whether we can run each entry present in Auto flush table in different timings like scheduled job does rather than running automatically every one hour by default "Table Cleaner" schedule? 

Regards,

Nivetha K.

[Naveen Thadur1]

Hi Can anyone help me understand what exactly the "force optimize" field do on auto flush from?

Thanks