Post reply

Notification

  • August 4, 2008 at 10:16 am

    #190646

    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

  • August 4, 2008 at 10:17 am

    #852780

    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.

  • August 4, 2008 at 10:49 am

    #852790

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

    Thanks

    Andrew SQLDBA

  • August 4, 2008 at 11:03 am

    #852792

    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.

  • August 4, 2008 at 11:54 am

    #852827

    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

  • August 4, 2008 at 12:21 pm

    #852855

    Thanks

    I have been looking thru the BOL under Notifications. Still reading

    I will look at what you suggested.

    Thanks

    Andrew SQLDBA

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

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