Post reply

If Job Failed, then Rerun the same job

  • January 5, 2011 at 10:21 pm

    #229258

    Hi,

    Wish you a Happy New year to Everyone.

    I have one query like if any jobs failed then we have to rerun the same job.

    I would be more happy, if anyone post a script.

    Regards

    Balaji G.

  • January 5, 2011 at 10:59 pm

    #1269867

    In the job itself, add the 1st step as a 2nd step, and configure the first step's failure action to go to the next step, instead of reporting failure.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • January 5, 2011 at 11:49 pm

    #1269876

    Thanks for your prompt response

    Regards

    Balaji G

  • January 6, 2011 at 3:11 am

    #1269955

    You can also configure the retry-attempts in the advanced tab of the jobstep.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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