I'm executing a bot to process around 130 xlsm sheets. The issue I was having was the bot errors out on the "Open Excel" action after about 60 spreadsheets. I am assuming it is running out of memory or something. It is not a spreadsheet issue because no matter which sheet the bot will error out around that point in time.
So I decided to run the bot in two intervals. Process 60 sheets first and end the process then restart it after 30 mins and continue where it stopped last.
How do I schedule the bot in a way that it restarts 30 mins after the first batch of sheets are processed without using a delay or pause command? The timeline to execute the first 60 sheets can be anywhere from 2.5-3 hours so cannot set a fixed time either in the schedule.
Please check the below docs to configure the schedules:-
If you have any questions please let me know.