ServiceNow Things to Know 17: Mass Deletion of Table Records

[PrashantLearnIT]

Navigate: Automated Test Framework > Administration > Table Cleanup

• Click New
• Tablename: <table to delete records>
• Age in seconds: 1 day's worth of seconds (60x60x24 = 86400) or a week or whatever you want to keep
• Cascade delete: true (that way it will clean up other data)
• Then there are more conditions you can add.
• Click Submit

 Let the scheduled job Table Cleaner run it's schedule.   To check and verify there is a scheduled job. 

Navigate: System Scheduler > Scheduled Jobs

 Search Name: Table Cleaner

 *Note the Next Action Date/Time

 If the scheduled job does not exist - create a new job to repeat every hour, but this is an OOB job and should exist.

 Once the scheduled job has run and completed - DELETE THE TABLE CLEANUP you created.   If not, you will continually delete the records from the table.

It can delete millions of records in very less time.

If my content helped you in anyway, please mark this content as BOOKMARK, SUBSCRIBE & HELPFUL

Best Regards,

Prashant Kumar (LearnIT)

YouTube Channel LearnIT: https://www.youtube.com/@learnitwithprashant

Blog LearnIT: https://medium.com/@LearnITbyPrashant

Prashant Kumar LinkedIn: https://www.linkedin.com/in/learnitbyprashant/

ServiceNow Community Prashant Kumar - https://www.servicenow.com/community/user/viewprofilepage/user-id/19635