Alert when backup fails

I am using SQL Server 2000, and I would like to configure an email alert to
occur when any backup job on the server fails. I have SQL Mail working,but
I don't see any obvious option in Alerts that would trigger a notification
when a backup job fails. I did a google search on the subject in this
newsgroup, and found several people asking this question, but none were
answered. Is there a way to configure an alert like this? Surely there
must be a way to accomplish this."J.Marsch" <jeremy@.ctcdeveloper.com> wrote in message
news:uH%23BFLQlDHA.1656@.tk2msftngp13.phx.gbl...
> I am using SQL Server 2000, and I would like to configure an email alert
to
> occur when any backup job on the server fails. I have SQL Mail
working,but
> I don't see any obvious option in Alerts that would trigger a notification
> when a backup job fails. I did a google search on the subject in this
> newsgroup, and found several people asking this question, but none were
> answered. Is there a way to configure an alert like this? Surely there
> must be a way to accomplish this.
>
The easiest way is probably to have scheduled jobs for the backups, then
send a notification if the job fails.
Simon|||Hello,
Thanks for Simon's help. I agree with him. Also, I'm including some
supplemental information below:
SQL Server Agent Mail (the SQLAgentMail service) can use its own domain
account and mail profile, rather than the one set up for SQL Mail. With SQL
Server, you can configure SQL Agent Mail to send e-mail messages when:
1. An alert is triggered.
Alerts can be configured to send e-mail notification of specific events
that occur without implementing SQL Mail. For example, alerts can be
configured to notify an operator of a particular database event that may
need immediate action.
2. A scheduled task (such as a database backup or replication event)
succeeds or fails.
E-mail messages can be sent to a list of recipients informing them of the
status of scheduled jobs for possible user action. You can expand the
capabilities of jobs to include sending a result set by e-mail to a list of
recipients. For example, a monthly inventory report could send SQL Agent
Mail notification to the designated operators and the result set to the
purchasing manager and supplier.
In this case, we can set the "E-mail operator" option in Notifications Tab
of Job Properties to send a notification when a database backup job failed.
E-mail operator specifies that an operator is notified by e-mail when a
Microsoft? SQL Server? event completes. Select the name of the operator to
notify by e-mail, or click the browse (...) button to add a new operator or
edit the properties of an existing operator. Also, select the completion
status about which the operator will be notified.
For additional information regarding this issue, please refer to the
following articles on the SQL Server Books Online.
Topic: "SQL Mail"
Topic: "Job Properties (Notifications Tab)"
Please feel free to let me know if this solves your problem or if you would
like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.