Setting up alterts on SQL Server

[sqlturbo]

I have not been very successful in setting up e-mail notification on the SQL Server box that runs on a cluster. Are there better ways of doing that? I am looking for ways to notify/send alterts like e-mail using a stored procedure, third party software, forwarding alerts to a non-clustered server for rely etc.,.
Thanks.

 

[tlbroadbent]

What problems are you having when setting up mail? What have you done thus far? What kind of mail system do you have? Check the following links.

How to Configure SQL Mail:

http://support.microsoft.com/default.aspx?scid=kb;us-en;263556

Common SQL Mail Problems:

http://support.microsoft.com/default.aspx?scid=kb;us-en;315886

HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server

http://support.microsoft.com/default.aspx?scid=kb;EN-US;153159

HOW TO: Send E-Mail Without Using SQL Mail in SQL Server

http://support.microsoft.com/view/tn.asp?kb=312839

The following links may require registration at the SQLTeam site.

Building a Mail Queue System

http://www.sqlteam.com/item.asp?ItemID=5908

Sending SMTP Mail using a Stored Procedure

http://www.sqlteam.com/item.asp?ItemID=5003

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[sqlturbo]

As the server is on a failover cluster, every time there is a failover, the SQL Mail Agent doesn't know about the mail profile that existed on the other node, though it has a MAPI profile with identical name and settings. And I have Outlook as my mailing system.
Through one of the links that you gave, I came across one KB Article (

http://support.microsoft.com/default.aspx?scid=kb;en-us;298723)

that says SQL Mail is not fully supportable when used on a SQL Server failover cluster.

Thanks for the helpful links though.