August 4, 2009 at 11:44 am
I created a simple maintenance plan, the 1st task was to backup a DB, 2nd task was to exec a stored procedure. I clicked the 1st task, then ctrl+click the 2nd task, right-click 2nd task and added a Precedence Constraint. That gave me a connector linking 1st task to 2nd task.
This seems like it sets up the flow of execution, but does it imply the 2nd task won't happen unless the 1st task executes successfully? I don't want the 2nd task to happen unless the 1st is succesful. I didn't see any options for setting this condition within the maintenance plan. How do I make it happen? Thanks for all your input.
August 4, 2009 at 11:51 am
right click on the "line" between the two. You will see Success, Fail and completion.
These are the conditions it will go to the next step. Default is On Success. (green line)
August 4, 2009 at 12:00 pm
Thanks, just what I was looking for... you would think that would have been included in the MS 'How To: Create a maintence plan' documentation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply