Maintenance Plan Fails, Job does not
-
I've had some issues recently with jobs created from a maintenance plan reported as successful even if the maintenance plan failed.
Has anyone seen this behavior? Any thoughts on how to correct this or what is going wrong?
Parts of the maintenance plan do succeed... but I'd like notification when any part of the plan fails. This specific maintenance plan only deletes old .trn files and then backs the log up. Sometimes the logs won't back up, like in the example a database is in simple mode.
-
How many subplans do you have? Just One?
-
Yes one. In this example it is a job created by clicking the "subplan schedule" button in the maintenance plan. This isn't some specially made job.
-
AdammadA (1/7/2010)
I've had some issues recently with jobs created from a maintenance plan reported as successful even if the maintenance plan failed.Has anyone seen this behavior? Any thoughts on how to correct this or what is going wrong?
I think it might be something to do with the colour of your arrows...Do you have any blue or red arrows connecting your tasks in your maint plan?
If you have a Blue (On Completion) arrows connecting your maint tasks when the task completes (Success or Fail) I beleive it will carry on with the next task, when it gets to the end it reports as completed and the job reports as being successful.
Same with fail, task when a task fails the plan carries on with the next task that the fail arrow is pointing at. when it gets to the end it reports as succeeding.
If the arrows were green (success) the job would fail when the task fails... Problem with that is you may want the other tasks to complete regardless of the other task.
I would recommend you check each task in your maint plan has completed...for example Backups report in the log, DBCC Check DB reports in the log.
Gethyn Elliswww.gethynellis.com
-
Here is what my maint plan history looks like... but my job is reported as a success...
-
OK what is the maint plan trying to do?
Is the maint plan doing what you want?
How often is the job scheduled to run?
Gethyn Elliswww.gethynellis.com
-
Hmmm...
So I may have figured it out.
If I try to backup a job that is in simple mode I think the Maintenance Plan will "fail" without causing the job to fail.
I don't particularly care about capturing that... but it lead me to believe NOTHING was being reported to the job as a failure.
As a test I created a new database set to "full" and tried backing up the log without backing up the db first. This DID generate a job failure (and subsequent alert I set up).
-
That would make sense, you can't backup the log of the database in simple mode.
Gethyn Elliswww.gethynellis.com
-
GRE-452109 (1/7/2010)
That would make sense, you can't backup the log of the database in simple mode.Yeah... it sorta makes sense.
I guess my problem is that why would it even bother reporting the Maintenance Plan as a failure but not the job?
I would think that if one fails the other should fail as well. So it seems to be a consistancy issue between what a Maintenance Plan failure is and what a Job failure is.
-
AdammadA (1/7/2010)
GRE-452109 (1/7/2010)
That would make sense, you can't backup the log of the database in simple mode.Yeah... it sorta makes sense.
I guess my problem is that why would it even bother reporting the Maintenance Plan as a failure but not the job?
I would think that if one fails the other should fail as well. So it seems to be a consistancy issue between what a Maintenance Plan failure is and what a Job failure is.
well i guess you could look it like this...You specified in the maint plan that you wanted the log backup of each and every database on the instance. Which the Maint Plan couldn't do becuase some of the DBs were in simple mode, so it told you it couldn't but the job still succeeded because all the T/Log that could be taken were taken.
Gethyn Elliswww.gethynellis.com
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply