SQL 2000 and sending mail on failure

This entry was posted by on Friday, 19 June, 2009 at

Had major probs recently when our SQL server failed to notify us of
failure until we really needed a backup. The setup with SQL 2000 for
mail is absolutely shocking and requires you to install Internet
Mail(remember that!!!) or Outlook on the server, create a MAPI profile
and then associate that MAPI profile with the sql server.
What we need to do is send mail on failure(and optionally on success).
The answer is xpsmtp – follow this guys instructions and sending mail
from SQL 2000 becomes a very easy thing.

 http://sqldev.net/xp/xpsmtp.htm

 I have setup an additional step in my jobs called fail which is called
when the job fails and sends mails to alert us lowly humans that once
again the computers have failed. Skynet will not be driven by SQL
2000….