Email alerts on cluster...

[Steve]

We are in the process of setting up a SQL Server 2000 cluster, but have been told that MAPI email is not cluster aware so we can't use the alert system.

Has anyone got any idea how to get round this or how to set up alerts in another way (eg: when a backup fails, can we send smtp mail?) etc

any feedback would be appreciated.

Regards

Steve

[MAK]

1. yep. u can do smtp email using XP_cmdshell command.
2. create jobs with xp_cmdshell for alerts can send email by

------------
Steve at 5/8/2002 7:09:44 AM

We are in the process of setting up a SQL Server 2000 cluster, but have been told that MAPI email is not cluster aware so we can't use the alert system.

Has anyone got any idea how to get round this or how to set up alerts in another way (eg: when a backup fails, can we send smtp mail?) etc

any feedback would be appreciated.

Regards

Steve