O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and Using Alerts

SQL Server alert objects are used to notify operators or launch jobs when events occur. You create alert objects in the SQL Server Agent node by right-clicking the Alerts container and selecting New Alert. Alerts fall into three primary categories when creating a SQL Server alert object. These are

SQL Server Event Alerts SQL Server event alerts monitor for errors within the SQL Server. You can monitor for severity levels or for explicit error numbers. You can also raise an alert when a message contains specific text. This latter option is most useful when you want to fire an alert if it mentions a particular object, such as a table or a database.

SQL Server Performance Condition Alerts You can also indicate that an alert ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required