Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Notification Expand / Collapse
Author
Message
Posted Monday, August 4, 2008 10:16 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
Hello Everyone
I am trying to setup notifications for all my 2005 database servers. The database(s) themselves reside on a SAN, while the database server is it own box. I would like to create a notification that will email me when the database server cannot communicate with the database.

So if the SAN were to be taken offline, I would like to receive an email stating that the database cannot be opened, or contacted, you get the point.

Thanks
Andrew SQLDBA
Post #546219
Posted Monday, August 4, 2008 10:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 13, 2014 12:38 PM
Points: 5, Visits: 461
You can base a notification on an error message number or severity level. I'm pretty sure a communication error like that should set something off.
Post #546220
Posted Monday, August 4, 2008 10:49 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
I know there should be something, but what? Do you happen to know of the Number?

Thanks
Andrew SQLDBA
Post #546234
Posted Monday, August 4, 2008 11:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 13, 2014 12:38 PM
Points: 5, Visits: 461
I know Error 40002 is a comm error but may be an app connection error, BOL should have a list. You can always define a custom error number, but it has to be > 50000.
Post #546237
Posted Monday, August 4, 2008 11:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
Take a look at "Create Event Notification" and the linked articles from it, in Books Online. Should have the data you need in there.

- 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
Post #546279
Posted Monday, August 4, 2008 12:21 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
Thanks
I have been looking thru the BOL under Notifications. Still reading

I will look at what you suggested.

Thanks
Andrew SQLDBA
Post #546309
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse