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?

Answer 1

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