Post reply

Multiple Schedules for a single SQL Server Agent Job

  • November 19, 2009 at 7:26 am

    #139462

    Hello Everybody

    I have a sql server agent job which is scheduled on a monthly basis. If the job fails, then I want to automate another job in a week time. I know that we can configure the job with retry attempts but I want it to run after 7 days, so I do not want the job to retry for 7 days.

    Like we have option for steps, when a step is failed then we can control it to continue with the next step or to fail. In the similar fashion do we have any such option for schedules where we can rerun the job when the first scheduled job fails?

    Thanks

    Sunny

  • November 19, 2009 at 8:10 am

    #1081582

    I have not seen the feature / option you are asking out of the box, only a custom script might be the solution.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • November 19, 2009 at 8:23 am

    #1081594

    Hi Bru

    Thanks for your response.

    Can you direct me with an example of the script or any link that is useful

    Thanks

    Sunny

  • November 19, 2009 at 8:45 am

    #1081621

    Hi

    I would have the last step of your monthly job update a table somewhere with a success/failure flag. You can then schedule your other job to run a week later. The first step of this job will check the table and only run if there's been a failure.

    cheers

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

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