30. Mass Deletion of Table Records
Import
·
May 26, 2024
·
article
Navigate: Automated Test Framework > Administration > Table Cleanup
- Click New
- Tablename:
- 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.
View original source
https://medium.com/@LearnITbyPrashant/30-mass-deletion-of-table-records-821ff9661da0?source=rss-d005fc598f0a------2