can we delete scheduled job records? Does it effect anything in production instance?

priyanka154
Mega Expert

Can we delete the scheduled job records? (ex:sys_trigger table)

12 REPLIES 12

Chuck Tomasi
Tera Patron

A better option is to just uncheck the Active flag.



Deleting is always risky.


Hi Chuck,


There is no Active field for sys_trigger records. Is there any alternative?



Thanks,


Priyanka


Sorry, I was looking at sysauto_script (Scheduled jobs.)



Per the documentation - don't touch the records in sys_trigger.



System Scheduler - ServiceNow Wiki



That being said, the better approach is to deactivate the corresponding record in sysauto_script (or sysauto_whatever) under System Definition> Scheduled Jobs (what I referred to before.)



You can find the corresponding job in the sys_trigger record in the Job context field as display here:



find_real_file.png



To stop incident auto close from running, go to the scheduled job and uncheck Active, then save.


Hi Chuck,


How can I find the scheduled job with this?


I have attached a screenshot of sys_trigger record.


find_real_file.png


Thanks,


Priyanka