Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

setup SQL alert notify DBA about windows event log error Expand / Collapse
Posted Friday, March 1, 2013 10:56 AM


Group: General Forum Members
Last Login: 2 days ago @ 2:45 PM
Points: 2,015, Visits: 3,809
Is there a simpler way to setup SQL alert in SSMS to notify DBA when an error log is written to windows event log.

For example if the event type is an Error, or I know the event ID, can I set up the alert in SSMS?

Post #1425646
Posted Monday, March 4, 2013 2:53 AM



Group: General Forum Members
Last Login: Tuesday, December 1, 2015 7:54 AM
Points: 134, Visits: 454
I wrote/modified a check script running every hour which keeps looking after certain keywords in the errorlog I predefined. If it finds something, I send me an email. But email is not reliable. Image you are in an meeting or otherwise prevented for any reason you can't read urgent the urgent mail in that time you should. And the more mails you receive, the harder it get's to distuingish beetween important and unimportant.

Query Shepherd
Post #1426146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse