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.
Edited bymontdidierMonday, August 03, 2009 1:32 AMspelling mistake