SQL Server Agent Alerts
Tuesday November 18, 2008
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
How To Create an Alert Using SQL Server Agent
step 5.Choose the type of alert from the drop-down menu. Your choices are SQL Server performance conditions (such as CPU load, free disk space, etc.), SQL Server events (such as fatal errors, syntax errors, hardware issues, etc.), and Windows Management Instrumention (WMI) events.
I didn’t see anything fo CPU Load or free disk space. Where is it?
Even I too can’t see the same.