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.
Time Required: 15 minutes
- Open SQL Server Management Studio and connect to the database server where you would like to create the alert.
- Expand the SQL Server Agent folder by clicking once on the "+" icon to the left of the folder.
- Right-click on the Alerts folder and select "New Alert" from the pop-up menu.
- Type a descriptive name fro your alert in the Name textbox.
- 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.
- Provide any alert-specific details requested by SQL Server, such as specific text included in the event report, parameters for performance condition alerts, etc.
- Click the "Response" icon in the New Alert window's "Select a page" pane.
- If you would like to execute a SQL Server Agent job when the alert occurs, click the "Execute job" checkbox and select a job from the drop-down menu.
- If you would like to notify database operator(s) when the alert occurs, click the "Notify operators" checkbox and then select the operator(s) and notification type(s) from the grid.
- Click OK to create the alert.
What You Need
- SQL Server 2005 or later
- SQL Server Management Studio