Open topic with navigation

Learn more about Toad for SQL Server at Dell Software Find solutions and downloads at the Toad for SQL Server Support Portal

Set up Event Notifications

Use Event Notifications to set up subscriptions to event generators so that notifications of events are received by the required targets. You can select the event generator to subscribe to (a SQL Server, database or queue) and select the event types for which you want to receive 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

To set up notifications for server level events

1. Select the Server Event Notifications tab in the upper pane of the Service Broker window.

2. Select .

To set up notifications for database or queue level

1. Select the Database Event Notifications tab in the lower pane of the Service Broker window.

   Note: You can also select Event Notification to run Event Notification Application wizard.

2. Select .

3. Review the following for additional information:

   Scope	Indicates where the event must occur in order to generate a notification. Server to generate a notification when the event occurs anywhere within the current SQL Server instance Database to generate a notification when the event occurs anywhere within the current SQL Server instance Queue to generate a notification when the event occurs in the specified queue
   With fan_in	Applies the 'With fan-in' option to the event notification. With this option, SQL Server sends only one notification for all event notifications that: Are created on the same event Are created by the same principal Specify the same service and broker_instance_specifier Specify WITH FAN_IN

Related Topics 

Configure Service Broker

of