Click here to Skip to main content
15,796,456 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

I have a scenario in which,
If a job for a segment has failed, then a job for subsequent days should not be run till the failed job has been re-run.

This has to be done in sql server, can some one suggest me some code for this.


1 solution

You just posted a 'homework' type statement. What have you tried? Where are you stuck?

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

For now, start from here:
Schedule a job that does what you want and then also configure it as per your need. Following posts might help in handling the re-run scenario.
If Job Failed, then Rerun the same job[^]
Re-running SSRS subscription jobs that have failed [^]
Share this answer
VJ Reddy 20-Jun-12 22:34pm    
Good answer. 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900