Auto Flush Execution

Priyanka Mathur
Tera Contributor

Hi Team,

I have created a auto flush record, I need to delete bulk records from sys_data_source table using auto flush functionality. Could you please assist me on how I can execute this.

find_real_file.png

Regards,
Priyanka

8 REPLIES 8

Hi Maik,

I did the same thing mentioned the article but didn't get any info or other details. Attached screenshot for reference.

find_real_file.png

Hi

did you check first whether the Table Cleaner really was executed before?

Kind regards
Maik

Chris Nack
Tera Expert

Hi Priyanka,

I know this is an old thread, but I believe you want your Matchfield to be a Date/Time field. Try using sys_created_on instead of sys_created_by (which is the User Id which created the records).

Community Alums
Not applicable

Hi @Priyanka Mathur 

 

The reference article shared by @Maik Skoddow resolves the question and it helped me to understand the scheduled job. 

SN KA:

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0694151

 

Like it's mentioned

1. You can navigate to the table 'sys_trigger.list' 

2. search for entry  "Table Cleaner' to validate the details

3. As said, it will execute every hour.

 

This must be in your case as well. 

 

Thanks!
Abhishek Pandey