Sequencing subscriptions in SQL Server Reporting services.


  • Hey Guys,

    Currently we have a requirement such that we need to send out multiple reports to multiple clients as an end of day process. Now these reports are totally different from each other but run off the same db. As of yesterday, i created a bunch of subscriptions with each of them being triggered by "timed subscription" which uses a common schedule. Ideally we would want these reports to go out in a sequence. 

    However, last night i noticed that these are fired at once causing locks. I had to manually kill a bunch of sessions to get things going. Scheduling them at predefined time is very difficult and unreliable.Is there a way for me to sequence them so that this parallel firing doesn't occur? 



    Friday, November 15, 2013 6:33 PM


All replies