how to delete 2 lakh records with out effecting performance ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2024 11:27 AM
what are the ways available in ServiceNow ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2024 11:45 AM - edited ‎10-31-2024 11:52 AM
Hi @Manikantahere ,
The Table Cleaner feature in ServiceNow helps delete old or unwanted data in batches, ensuring minimal impact on performance. To create a new Table Cleaner, go to sys_auto_flush_list.do, click New, and complete required fields like Table Name, Matchfield (e.g., sys_created_on), and Age in seconds. You can set conditions for deletion or remove all records of a specified age. Finally, click Submit to save and activate the rule, which will run with the next Table Cleaner job.
Please go through below kb articles
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0694151
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717791
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand