April 3, 2014 at 10:44 am
Our backups by default go to a network location, but I'd like to modify our maintenance plans to backup to an alternative location if the primary location isn't available. I've setup two Backup Database Tasks where the second one runs only if the first one Fails, and if the second one runs (on first one's failure) it then sends a notification to me so I know this occurred.
The Plan is running as expected, when I simulate a bad path in the first Backup Task the second one runs and the notification is sent, but the Job shows failure. I'd like to show the job as Successful when this occurs since I'm handling the issue and notification within the Plan, but I'm unable to find out how. I've set FailParentOnFailure to False on the Plan and I've changed the MaximumErrorCount to 2 with the assumption that this would help, but neither didn't.
Also I'm running into this in both SQL 2008 and SQL 2012. Thanks for any suggestions.
Sam
April 3, 2014 at 11:35 am
Create a step 3 in the job and modify the job control for the Step2 as
On sucess -- Goto Step 3
On failure -- Exit reporting as failure.
In step 3, just have any TSQL Statement like select @@servername.
--
SQLBuddy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply