Maintenance plan step fails but overall considered success, seems like contraints doesn't register step failure and choose the other path.

Question

Hello Everybody,

I'm running MSSQL 2005 SP3.

I've prepared a Maintenance Plan that should, upon the failure of any particular step, write an error to the LOG file with RAISEERROR and then email a failure notice to the operator (myself). I'm also receiving the Maintenance Plan report. I'm currently getting success messages, but from the more expansive report I can see that one of the steps fails (that in itself was easly fixed).

What I have not fixed or understood is why the failed step contraint appears to have registered as "Success" rather than failure. I initially thought it was because the error was listed as "Database 'DATABASENAME' will not be backed up because it does not have its recovery model set to Full or BulkLogged." The error number is 0.

Is this perchance being interpreted as the error code and thereby not being registered as failure?

I'd like to solve this so I have some confidence in the "Success" or "Failure" reports emailed to me daily.

Answer 1

It depends on what action you have setup as part of job/steps for failure and success status. Would it be possible for you to share the job definition in TSQL/Screenshot forms?

Thanks.

---

Vikas S. Rajput