Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
faizankh
Starting Member
8 Posts |
 Posted - 2007-12-10 : 10:28:04
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-10 : 11:24:01
|
| 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).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-10 : 12:54:17
|
| Have a look at Gert's smtp solution for SQL Server 2000.http://sqldev.net/xp/xpsmtp.htm |
|
|
|
|
|
|
Sql Server 2000 Alert/Notification