Managing Alerts
Using alerts, you can send e-mail, pager, or Net Send alerts when errors occur or when performance conditions are reached. For example, you can configure an alert to send a message when a Log File Is Full error occurs, or when the number of deadlocks per second is more than five. You can also execute a job on an alert event.
Using Default Alerts
Default alerts are configured when you configure features such as replication. The names of alerts configured when you set up replication begin with Replication: and include the following:
Replication: Agent Success. An alert that tells you that the replication agent was successful
Replication: Agent Failure. An alert that tells you that the replication agent failed
Replication: Agent Retry ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.