How does sys_auto_flush works ?

[guillaume92]

Hello Community,

I'm trying to make a purge on some tables, i thought using the sys_auto_flush was a good idea, but i don't understand how it works.

I tried to create this entry (for testing) :

I want to delete all records on the table u_savxdsl that have been created 10 seconds ago where the ID contrat is 182736459826.

So i created a record with this conditions, wait 10 seconds (almost 2 minutes in fact ), but my record still exists.

I think i miss something about this functionnality, but i don't know what. Someone has a clue ? The Wiki isn't very explicit

Thks,

Guillaume

[Robbie · Accepted solution]

Hi Guillaume,

Whilst you've set the 'Age in seconds' field under certain presumptions, this field doesn't actually correlate to when the Auto flush runs. This field is used as part of the query or match for what data to delete. (Along with the 'Matchfield' field)

The actual scheduled job that invokes the Table Cleaner (sys_auto_flush) runs every hour. Check your table now as its been longer than an hour and the record(s) should be deleted.

Please can you mark this answer as correct and helpful by clicking on the buttons via your post link (How does sys_auto_flush works ? ) to help close out open questions and aid others with the same/similar questions.

Thanks,

Robbie

[guillaume92]

Thank you Robbie,

I was looking about the system behind the sys_auto_flush table, effectively, there is a job called BulkTableCleaner

Thank you again

[Tushar Walveka2]

The Table Cleaner scheduled job runs the table cleaner every hour. To view the list of tables that are auto-cleaned, in the Navigator filter, type: sys_auto_flush_list.do.

All records with [MatchField < (current_time - Age in seconds)] are deleted.

• The MatchField field represents a Date/Time column in the table that you are trying to clean up.
• The Age in seconds field represents a value in seconds.

[Naveen Thadur1]

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

Thanks