SSRS Data Driven Subscriptions – Queueing Mechanism


When thousands of data driven subscriptions are fired in SSRS, they are stored in ReportServer.dbo.Notifications table. Based on the workload of SSRS Service, subscriptions are picked from this table for processing.

This means even if SSRS Server / Windows Service is restarted, any data driven subscriptions initiated (but not actively running) would still be delivered. SSRS Subscription mechanism seems to be robust enough to send (in our case it is SFTP) many thousands of subscriptions without any problem.

That’s pretty good !

Advertisements

About EasyBIJegan

Business Intelligence Developer
This entry was posted in SSRS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s