SQL Server Agent Alerts

SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center.

Read the tutorial: Creating Alerts with SQL Server Agent