How many SSRS reports the execution option can be set to run at the same time?

Hi

There shall be atleast 1000 reports that could be created and the execution option can be set for daily and at 00:00 hrs. So my question is how many reports can get refreshed at the same time?

Thanking you in advance

regards

Sai

There is no theoretical limit to the number of reports that can be scheduled for the same time. I would set them up to run off of a shared schedule. When the schedule fires the report executions will be queued up to run. The Report Server will attempt to run as many as possible without consuming to many resources. As it works through the reports, it will bring in more to process. This means that some reports will be run at 12, but others will run later as they are taken from the queue. It will depend on the type of reports and the speed of the machines to determine how long it will take.

If the reports take to long you can always add additional machines to the configuration to allow for more throughput.