Microsoft Corporation

Newsletters & RSSEmail to a friendSubmit to Digg

Suggested Reading

Introduction to SQL ServerCreating Tables in SQL ServerSQL Server Data TypesSQL Server BackupsSQL Server Stored Procedures

Most Popular

Microsoft Access FundamentalsSQL Server Stored ProceduresDatabase Normalization BasicsDatabases for BeginnersCreating Forms in Access

How To Create an Alert Using SQL Server Agent

Here's How:

1. Open SQL Server Management Studio and connect to the database server where you would like to create the alert.
2. Expand the SQL Server Agent folder by clicking once on the "+" icon to the left of the folder.
3. Right-click on the Alerts folder and select "New Alert" from the pop-up menu.
4. Type a descriptive name fro your alert in the Name textbox.
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.
6. Provide any alert-specific details requested by SQL Server, such as specific text included in the event report, parameters for performance condition alerts, etc.
7. Click the "Response" icon in the New Alert window's "Select a page" pane.
8. 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.
9. 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.
10. Click OK to create the alert.

What You Need:

• SQL Server 2005 or later
• SQL Server Management Studio