Scheduled Jobs

[Isha Panditrao]

Hi Service Now Experts,

I have a specific requirement and would appreciate your guidance to achieve it. I have a table which contains tasks assigned to different assignment groups. I need to close all the active tasks assigned to a specific group. This table keeps on updating and the closure task needs to be repeated whenever there are new active tasks assigned to this specific group. I have to write a scheduled job to achieve this. If I schedule the job to execute daily, there is a huge performance impact as there are thousands of records that are to be closed. I am confused as to when and how to execute the scheduled job, and also can I use setLimit() and close the tasks in batches to balance the performance impact. In this case, how do I execute the schedule job? 

[Dr Atul G- LNG]

Hi @Isha Panditrao 

1st  point, it is not SNOW, it is SN or ServiceNow.

2nd point is better to use the flow designer for this and look up actions there set the limit and run the job at different timings.