setup SQL alert notify DBA about windows event log error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » setup SQL alert notify DBA about windows...

setup SQL alert notify DBA about windows event log error

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Friday, March 01, 2013 10:56 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:36 PM
Points: 1,599, Visits: 2,773

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?

Thanks

Post #1425646

SQL Pizza

Posted Monday, March 04, 2013 2:53 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

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.

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1426146

« Prev Topic | Next Topic »

Permissions