Post reply

Disable Job

  • September 27, 2005 at 12:28 pm

    #102822

    When our mail server is down (unfortunately, not an uncommon event), all of the scheduled jobs using XP_Sendmail fail. In addition, we end up with processes that hang which usually ends with restarting the server.

    I'm looking for, but haven't been able to find a script I can execute which will disable a series of jobs. I'll then create a second script to enable once the mail server is back up.

    Any info would be greatly appreciated.

     

  • September 27, 2005 at 12:38 pm

    #593411

    You could just write a script to update the msdb.dbo.sysjobs table (enabled column) and set it for each job you want disabled when this s.n.a.f.u occurs.

     



    A.J.
    DBA with an attitude

  • September 27, 2005 at 12:43 pm

    #593417

    Check out sp_update_job in bol

  • September 27, 2005 at 1:07 pm

    #593431

    Thanks to all. That's what I needed.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply