THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Management Pack for SQL Agent Alerts

I have finished my article about suggested SQL Server Agent Alerts. Perhaps calling this a "Management Pack" is OTT, but hopefully it will be useful to some of you folks.

We are talking about having Agent sending email to us when SQL Server writes messages to EventLog. The functionality has been in the product since version 6.0, but I have always lacked some good "default setting". I'm talking about some easy way to tell Agent to notify me for messages which I typically want to be notified for. (Many of you are already using various Management software that has this functionality, so this won't be for you :-) ).

I very much welcome feedback, you find all information in the article:

http://www.karaszi.com/SQLServer/util_agent_alerts.asp

PS: I've blogged about related topics here: http://sqlblog.com/blogs/tibor_karaszi/archive/2009/02/23/where-s-that-sys-messages-management-pack.aspx, and here: http://sqlblog.com/blogs/tibor_karaszi/archive/2009/05/14/sp-altermessage-is-back-in-business.aspx.

Published Monday, June 01, 2009 10:05 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

jerryhung said:

Good work, Tibor

I now use DumpEvt to import Event Log data from list of servers, and I can search or report on the centralized server

Most of the time I try to find error messages from reading in just all SQL error logs, as most of critical errors will be in both SQL error log and Event Log

June 1, 2009 3:44 PM
 

Linchi Shea said:

> but I have always lacked some good "default setting".

I'm sure you didn't really mean it :-)

June 1, 2009 3:50 PM
 

Sankar Reddy said:

Thank You. As an involuntary DBA, I felt this is very useful and deployed.

June 26, 2009 1:48 AM
 

Roger Falor said:

I'm trying to set a password change alert but it doesn't work:

sys.messages.is_event_logged is set to 1

EXEC msdb.dbo.sp_add_alert @name=N'password change - 21451',

@message_id=21451,

@severity=0,

@enabled=1,

@delay_between_responses=1800,

@include_event_description_in=1,

@category_name=N'[Uncategorized]',

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

Any suggestions?

January 25, 2011 1:56 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement