SQL 2000 and sending mail on failure
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.
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....
