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.
| Author |
Topic |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-06-11 : 10:09:09
|
| Hi Gurus,Please can you give me a list of severe errors/error that I should setup for notification ALERTs on a production database.VERY VERY Urgent Please.Thanks & RegardsrajRaj. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-11 : 11:51:25
|
| serious errors already get reported to your system/application event logs. Do you monitor those with any monitoring/alerting tools? If you do, then it is pretty simple to send custom alerts into the application event log from your own code (from sql jobs, or dts/ssis packages, etc.)We are now using microsoft MOM for monitoring and this is one of the areas that it really excels in. It falls down in some other areas, but it does this specific task pretty well.-ec |
 |
|
|
|
|
|
List of Best Practices for ALERT Notification.