Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

About Event Notifications

Use Event Notifications to generate an alert when an event matching your criteria occurs. You can set up notifications for events that occur:

At the server level: for example, create database, alter endpoint, etc. This level includes SQL trace events.
At the database level: for example, create table
At the queue level: for example, queue activation or queue disabled

Set Up Notifications

Notifications occur in response to an event. In order to receive notification of an event, you must set up an event notification.

To set up notifications for server level events

Select the server node in the tree.
Select the Event Notifications tab.
Right-click the display area of the Event Notifications tab and click Create.
On the General page, complete the notification name, the target service and scope.
Specify the events that generate the notification on the SQL Events and Trace Event pages.

To set up notifications for database or queue level events

Select the databases node in the tree.
Select the Event Notifications tab.
Right-click the display area of the Event Notifications tab and click Create.
On the General page, complete the notification name, the target service and scope.
Specify the events that will generate the notification on the SQL Events and Queue Events pages.

Note: The options available are controlled by the scope selected.