I have a sql server 2000 in a Active/Passive environment. I'm trying to create an alert to send me messages on my email(MS outlook) for failed jobs. I cannot use SQL MAIL in the current environment. Is there any other way to set up notification. I really need this. I have a seesion job thats runs every 2 min to clear dead sessions. If this jobs fail to run it will make the application slow. Please Help.
How are you defining a dead session? You've got to get down to the culprit of the slowdown and not just kill spids. That is not fixing the problem, but rather just putting a bandaid in place.
Why can't you use SQL Mail in your environment? SQL Mail works perfectly fine on a cluster with SQL Server 2000. It just isn't supported by Microsoft. We had it running just fine there for a few years (we are now on 2005 so are using Database Mail, which is supported by MS on clusters).