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:
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.