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

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