Microsoft SQL Server
Automatic retries in a SQL Agent job
Many SQL Agent jobs can be run automatically using the scheduler to run the job at specified times. But sometimes it would be better to run the job when specific criteria have been met, instead of at a specified time. For instance, when the data warehouse has finished loading.
This blog post will show how to create a job that starts and then waits / retries until given criteria are met.