Notification

  • 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

  • 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.

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

    Thanks

    Andrew SQLDBA

  • 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.

  • 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

  • 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