Audit Server Start and Stop Event Class

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Audit Server Start and Stop Event Class

Author

Topic

Carat
Yak Posting Veteran

92 Posts

Posted - 2008-09-07 : 15:30:51

I'm trying to make an event notification thats going to email me whenever a certain service stops or restarts. I read that you can use the "Audit Server Start and Stop Event Class" but the problem is that I can't find it. I searched in BOL and the event classes that I found were the following:

AUDIT_SERVER_ALTER_TRACE_EVENT
AUDIT_SERVER_OBJECT_GDR_EVENT
AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT
AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT
AUDIT_SERVER_OPERATION_EVENT
AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT
AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT
AUDIT_SERVER_SCOPE_GDR_EVENT

I made an event notification containing all off the above event classes and restarted the SQL Server Agent service but it didn't gave any result.

Has anyone got an idea?
Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-07 : 16:30:02

You'll need to monitor for the SQL Server services outside of the SQL Server tools. We use MOM to monitor our services, but it just checks the event log for the related messages.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Carat
Yak Posting Veteran

92 Posts

Posted - 2008-10-08 : 05:43:41

Unfortunately we do not use MOM but I spoke with the System Administrators and they told me that they use Nagios. This will probably do the trick.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources