Setting SQL Agent alerts
Regarding creation of SQL Agent job alerts
1) Allow use of the word filter to generate alerts without necessarily specifying a particular error number or a particular severity code.
2) Allow for a "Greater Than or Equal To" value for severity.
On the SQL Agent job Notifications:
3) You need a better way to handle job failures for jobs that might get executed many, many times a day and might be failing for a while before someone notices.
Upvotes: 1<=-=Jun 6 2007 10:38AM=-=>
Thank you for your suggestion. We are considering these suggestions for a future release of SQL Server, but probably not SQL Server 2008. For future reference if you can put each suggestion in a separate filing it makes it easier for us to consider them individually.
-Richard Waymire<=-=Oct 29 2008 1:48PM=-=>
We are considering it for SQL11.Thanks for the feedback!