Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, March 1, 2013 10:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:46 PM
Points: 1,776, Visits: 3,222
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
Posted Monday, March 4, 2013 2:53 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:41 AM
Points: 118, Visits: 355
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 »

Add to briefcase

Permissions Expand / Collapse