SQL Server Performance

Transact SQL for SQL Agent Job Disable

Discussion in 'SQL Server 2005 General Developer Questions' started by yhchan2005, Oct 14, 2010.

  1. yhchan2005 Member

    Hi, in BOL, only manage to get the way using Management Studio to enable disable SQL agent job, would like to check what is the transact SQL for Agent job enable + disable.
    Thank.
  2. Luis Martin Moderator

    To me, there is no single TSQL to do that.
  3. ashish287 New Member

    select * from msdb..sysjobs
    and see the option enabled. If its 1 then enabled = true else false for 0.

Share This Page