SQL 2k5 sp2 Alerts not working

Question

SQL 2k5 sp2 Alerts not working

sunshine-587009

SSCrazy Eights

Points: 8981
More actions
September 26, 2008 at 10:18 am

#213320

SQL 2k5 sp2 Alerts not working on our clustered environment. Anyone have this issue? Is there a work around?
¤ §unshine ¤

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Have you made sure the alerts are set up with a working DB Mail account and all that?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 2

Yes, it's a 64bit and our jobs are notifying us using dbmail.

¤ §unshine ¤

Glen SSCertifiable Points: 6737 More actions · Answer 3

When you are saying that it does not work, what do you mean?

Any error messages? Did you try sending a test email?

Did you enable db mail on both servers?

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 4

DBMail works just fine. The Alerts are not working. When the server shuts down, the log gets full, severity errors happen, it does not send out the alert. DBMail works with stored procedures, jobs and test emails. DBMail is not the issue. We have shut down the server, had full logs on databases and do not receive the alerts.

¤ §unshine ¤

Glen SSCertifiable Points: 6737 More actions · Answer 5

Any related error messages? (It should be in Agent Error log).

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 6

SQL Server error logs, logged the full log on a database, however there are no error logs on sql server agent since the alert was never sent.

¤ §unshine ¤