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 !


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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s