SQL Code to enable or disable jobs

SQL  Code for enabling sql jobs

 

USE [msdb]

GO

Code for disabling SQL job

EXEC msdb.dbo.sp_update_job @job_id=N'jobid', @enabled=0

GO

waitfor time '03:30:00'

Code for Enabling SQL job

EXEC msdb.dbo.sp_update_job @job_id=N'jobid', @enabled=1

GO

Code for Execute SQL job

EXEC msdb.dbo.sp_start_job @job_id=N'jobid'