Processing more than 10,000 records with a scheduled job.

[MiY]

I would like to update/delete more than 10,000 records with a scheduled job, but I am concerned that this may affect performance.
I would like to know the best practices for processing large volumes of records with a scheduled job.

[MiY]

@Nilesh Pol -san
Hi, Thank you for your replying.
Sorry, I was wrong about the number. I'm planning to run the process on 200,000 records. Will there be any performance issues?

[KrishnaMohan]

Hi @MiY 
Yes, scheduled jobs in ServiceNow can significantly impact performance, especially if they are long-running or process large amounts of data. check below link for best practices.
https://www.servicenow.com/community/csm-forum/what-is-the-best-practice-on-fix-scripts-scheduled-jo...

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

If my response helped please mark it correct and close the thread so that it benefits future readers.

Thanks and Regards,
Krishnamohan

[Nilesh Pol]

@MiY Recommended, to avoid performance issues, Break into the chanks (20k each) using filter. and the update job OR delete Job.