Notification

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Notification

Notification

Rate Topic

Display Mode

Topic Options

Author

Message

AndrewSQLDBA

Posted Monday, August 04, 2008 10:16 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 6:50 PM
Points: 793, Visits: 2,268

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

heftyp

Posted Monday, August 04, 2008 10:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:10 PM
Points: 5, Visits: 413

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

AndrewSQLDBA

Posted Monday, August 04, 2008 10:49 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 6:50 PM
Points: 793, Visits: 2,268

I know there should be something, but what? Do you happen to know of the Number?

Thanks
Andrew SQLDBA

Post #546234

heftyp

Posted Monday, August 04, 2008 11:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:10 PM
Points: 5, Visits: 413

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

GSquared

Posted Monday, August 04, 2008 11:54 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

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

AndrewSQLDBA

Posted Monday, August 04, 2008 12:21 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 6:50 PM
Points: 793, Visits: 2,268

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 »

Permissions