Online Documentation for SQL Manager for SQL server

Alerts manager


The Alerts manager allows you to browse the list of alerts and manage them efficiently.

 

To launch the tool, select the Services | SQL Server Agent | Alerts main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | Alerts item from the context menu.

 

Alerts - Alerts manager

 

 

The list displays the alerts as a grid with the following columns: Alert Name, Type, Enabled, Error Code, Severity, Last Occurrence, Sent Pager, Net Sent, Server.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

Hint: Enabled/disabled alerts are differentiated in the list by their icons: icons for disabled alerts are grayed out.

 

Right-click an item within the list to call the context menu allowing you to create a new alert and specify its properties using Alert Editor, edit, delete the selected alert, refresh the list, or show/hide columns of the list. Using the context menu you can also export the list of alerts to any of supported output file formats.

 

Alerts management tools are also available through the Navigation bar of the Alerts manager.

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.