email alerts

I was wondering if there was a nice easy way to use a simple tool to email
me when my sql2k server is having some issues? I have been looking at how to
configure SQLAgentMail and SQL Mail but do I really need a mapi client? Or
what is the easiest way to do this? Thanks for the info.
Jason
You can use xp_smtp_sendmail, just use smtp and not have to
deal with the MAPI issues. You can find the download and
information at:
http://www.sqldev.net/xp/xpsmtp.htm
In terms of alerts, you can run a job in response to alerts.
So if you had a job that sends an email notification using
xp_smtp_sendmail, you could just fire that job in response
to the alert.
-Sue
On Mon, 29 Mar 2004 12:32:38 -0600, "JasonMeyer"
<jason.meyer@.nospam.isd623.nospam.org> wrote:

>I was wondering if there was a nice easy way to use a simple tool to email
>me when my sql2k server is having some issues? I have been looking at how to
>configure SQLAgentMail and SQL Mail but do I really need a mapi client? Or
>what is the easiest way to do this? Thanks for the info.
>
>Jason
>
|||... and here are some other options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message news:ur0h60p3vl3i5es10df9dtud60jp2bvpb9@.4ax.com...
> You can use xp_smtp_sendmail, just use smtp and not have to
> deal with the MAPI issues. You can find the download and
> information at:
> http://www.sqldev.net/xp/xpsmtp.htm
> In terms of alerts, you can run a job in response to alerts.
> So if you had a job that sends an email notification using
> xp_smtp_sendmail, you could just fire that job in response
> to the alert.
> -Sue
> On Mon, 29 Mar 2004 12:32:38 -0600, "JasonMeyer"
> <jason.meyer@.nospam.isd623.nospam.org> wrote:
>