raising alerts on multiple errors 1

[ksbrace]

Hello,
I am in the initial phase of setting up backups on a sql server 2005 instance. Is there a way to alert me of all errors during the backup job without having to create an alert for each error? Under Alerts will be raised on:
Error number: and Severity:, with Severity being a drop down box with several errors, but I can only select one. Thanks in advance,
Kelly

 

[mrdenny]

Just setup the job to send a notification on failure. It will then send an email any time there is any faiure.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sqlcasey]

Just setup the job to send a notification on failure. It will then send an email any time there is any faiure.

this is assuming you have already set up dbmail on the server, correct?

 

[Catadmin]

Not necessarily DBMail. As long as you've set up some sort of Operator (NetSend, Pager, or Email) you can use Notification. Of course, the EMail portion won't work if DBMail isn't configured, but you can still use the other two options.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"