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