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.
   

   yhchan2005, Oct 14, 2010

   #2
2. Luis Martin Moderator

   To me, there is no single TSQL to do that.
   

   Luis Martin, Oct 15, 2010

   #3
3. ashish287 New Member

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

   ashish287, Oct 17, 2010

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in