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.

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