The CreatorCon Call for Content is officially open! Get started here.

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