Explain architecture of SQL Server Notification services?
Submitted by: AdministratorNotification 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online SQL Notification Services Job Interview Questions And Answers
Top SQL Notification Services Questions
☺ | Explain OPENQUERY function and OPENROWSET function? |
☺ | Define data, entity, domain and referential integrity? |
☺ | Define transaction and transaction isolation levels? |
☺ | How does Notification Services Work? |
☺ | What is Isolation Levels? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |