Advice - SQL Maintenance plan ignoring steps.

Question

Advice - SQL Maintenance plan ignoring steps.

ecksfiftyone

SSC Enthusiast

Points: 177
More actions
March 27, 2017 at 9:01 am

#319922

SQL 2008R2 - I setup a maintenance plan that backs up all of my databases. On success, it is supposed to cleanup backup and restore history, then run dbcc checkdb. The job doesn't do anything after the backup. It simply backs up the databases and stops. There are no errors or issues I can see. The rest of the plan is just ignored.
I dont understand what I'm doing wrong. Can someone point me in the right direction? What should I check when my maintenance plan is simply ignoring steps (tasks)?
Here is an image of the plan. (Note: I changed the constraints from success to completion for troubleshooting as seen in this image. It didn't help)
Any advice is apreciated, thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Your Check Database Integrity Task is waiting for the History Cleanup Task and the Notify Operator Task to complete. But NOT will only be invoked if BUDT fails, which is why you're waiting for something that isn't going to happen. I would recommend that you remove the constraint between NOT and CDIT.

John

ecksfiftyone SSC Enthusiast Points: 177 More actions · Answer 2

OH, so BOTH must occur for this task to run? I was under the impression that the task would run if EITHER path was taken to get there.

Thanks, I shall try that.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

You can edit the properties of the constraint to change it to an OR instead of an AND (at least you can in SSIS, and a Maintenance Plan is just a cut-down SSIS package). I think when you do that, the constraints are represented as a dotted line. But you might not want to do that, depending on whether you still want CDIT to run if BUDT or HCT fail.

John