sql server reporting services: Report subscription execution order in a schedule? -- sql server reporting services

Report subscription execution order in a schedule?

Susan
10/26/2005 4:18:29 PM

sql server reporting services: When a schedule is triggered are the subscribed reports all executed
immediately or sequentially?

Re: Report subscription execution order in a schedule?

Robert Bruckner [MSFT]
10/26/2005 8:03:34 PM

You can configure the maximum number of items that will be worked on in
parallel. Set the MaxQueueThreads element in the RSReportServer.config file
to the max number. You can not control the amount of events/reports we pick
up, it will be Min(2*num of procs, MaxQueueThreads).

Some more information about load-balancing for subscriptions in a webfarm
scenario can be found in this blog article:
http://blogs.msdn.com/bimusings/archive/2005/08/17/452865.aspx

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]