Explain architecture of Notification services.Notification Services consists four components
1) Subscription: Subscription data can be added using (SMO) Subscription Management Objects to Notification Services application.
2) Events: Events get populated to events table with the help of Event providers.
3) 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.
4) 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.
What can SQL Server Reporting Services do?
What can SQL Server Reporting Services do? - You can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources......