Enable/Disable Sql Server Agent using a t-sql script

Question

Is it possible to enable or disable the sql server agent using t-sql?

score 48 · Accepted Answer · answered Apr 19 '12 at 18:08

48

exec msdb..sp_update_job @job_name = 'Job Name', @enabled = 0 --Disable
exec msdb..sp_update_job @job_name = 'Job Name', @enabled = 1 --Enable

answered Apr 19 '12 at 18:08

Russell Fox

1

Thanks! is there a way to enable/disable the agent itself too? – Jill Apr 19 '12 at 18:16
2

You're welcome! And yes, google xp_servicecontrol (I've never use it). – Russell Fox Apr 19 '12 at 18:23

score 7 · Answer 2 · answered May 08 '18 at 19:58

7

You can use this to set it ON or OFF

   EXEC xp_servicecontrol N'stop',N'SQLServerAGENT'
   EXEC xp_servicecontrol N'start',N'SQLServerAGENT'

answered May 08 '18 at 19:58

2 Answers2