Post reply

sql agent job schedule no longer runs

  • November 22, 2010 at 12:54 pm

    #241571

    Hi all,

    I disabled several jobs using this code from http://www.mssqltips.com/tip.asp?tip=1400

    sql server 2005

    -- disable

    UPDATE MSDB.dbo.sysjobs

    SET Enabled = 0

    WHERE Enabled = 1;

    -- enable

    UPDATE MSDB.dbo.sysjobs

    SET Enabled = 1

    WHERE Enabled = 0;

    I re enabled the jobs with the next part and now the scheduled task do not run. Any ideas? the job runs if I execute them manually just not when scheduled. Agent is running

    many thanks

  • November 22, 2010 at 2:08 pm

    #1254046

    Did you check error log?

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • November 22, 2010 at 2:18 pm

    #1254054

    yes no errors.

  • November 22, 2010 at 3:20 pm

    #1254091

    restarting sql agent seems to fix the issue.

  • November 22, 2010 at 5:09 pm

    #1254118

    Right click on the job and enable it or refresh it.

    Regards,

    Pavan Srirangam.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

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

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