May 13, 2008 at 7:18 am
Hi all,
How can i restart the job when i see the error in error log about backup failed!! Also i am trying to script out so if i see failed backup error during the time job runs i need to restart the job and get back up finish with out error!!
Please help!!
Thanks
Pat
May 13, 2008 at 7:27 am
On the job step you can specify a number of times to retry a step on failure along with how long to wait between retries. You really need to be notified when a job fails and determine why your backups are failing and try to fix that problem first.
You could also define an alert that detects when the job(s) fail and run the job again from the alert.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 13, 2008 at 12:29 pm
Once you determine which step failed and where you want to restart, right-click on the job in SSMS and select "Start Job at Step...". Then you can select which step you want to restart at.
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply