Home Forums SQL Server 7,2000 T-SQL Job restart on condition RE: Job restart on condition
Jeremy Kemp
SSCertifiable
Points: 6754
More actions
June 4, 2003 at 9:19 am
#459752
Within the actual job, if you open up the step and select the Advanced tab, there is facility for the step to retry. You can set the number of retry attempts and the retry interval (in minutes).
This only works if the step actually fails.
Jeremy