Batching and updating list of records

[swapnil_singh]

Hi ,

I have a requirement where I need to update more than 200k+ records through background scripts or scheduled job but to be done via pagination/batching concept..update 1000-2000 records at one time and move onto to the next batch so that it does not have a load on the instance..it keeps on checking the batches untill all 200k records are not checked.

Can someone help on this??

[Mike_R]

If you are on Tokyo, did you look into the Update Jobs feature

https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/administer/managing-data...

[swapnil_singh]

Thanks for your response but we are not yet in Tokyo,still in Rome version.

[Mike_R]

What table do you need to update? I think we can probably use flow designer

[swapnil_singh]

Target tables are cmdb server ones ..as it will be a one time activity, hence only scheduled job or fix script(background script) is allowed