SQL Server notification services interview questions
SQL Server notification services - posted on August 27, 2008 at 17:10
pm by Amit Satpute
What are Notification services?
Notification Services are services which send notifications to the interested
entities based on what they would like be notified on.
It is one of the features of the SQL Server.
What are the basic components of Notification services?
The following terms are the components of Notification Service:
Event: an action that occurred affecting the specified data.
Subscriber: an entity that wants being notified on occurrence of an event.
Subscription: an act by which subscriber describes when and what he wants to be
notified as.
Notification: a channel of communication.
Explain architecture of Notification services.
Notification Services consists four components
Subscription
Subscription data can be added using (SMO) Subscription Management
Objects to Notification Services application.
Events
Events get populated to events table with the help of Event providers.
Generator
When events are populated into events table, the generator wakes up
and starts processing rules that are attached with subscriptions. The generator
checks to see if any events match them. The generator starts creating
notifications and fills the Notifications table, if matches are found.
Delivery (notifications)
When notifications arrive in Notifications table, the distributor
wakes up and starts processing each notification, formats it and delivers them
using specified channel.
How Does Notification Services Work?
Subscription data can be added using (SMO) Subscription Management Objects to
Notification Services application. Events get populated to events table with
the help of Event providers. When events are populated into events table, the
generator wakes up and starts processing rules that are attached with
subscriptions. The generator checks to see if any events match them. The
generator starts creating notifications and fills the Notifications table, if
matches are found. When notifications arrive in Notifications table, the
distributor wakes up and starts processing each notification, formats it and
delivers them using specified channel.
|