So we have a small number of SQL Server 2005 Servers running a lot of SSRS reports, which is running into issues where the servers cannot keep up with the total number of reports, that users are scheduling on shared schedules, running at once.
Has anybody seen or know of a good way to implment some sort of job queues or lists?
For instance a '6 am' job list that will contain all of the reports that run at 6 am, and then one agent job will start running the reports in the list one after the other. This would keep the reports from running thier mini-DDOS attack against thier own reporting servers.
We would prefer that we not have to remove the scheduling functionalty that is already built into SSRS, we just want the agent to not kick off 3000+ reports all at the same time, without having to manually schedule each one to run 1-2 seconds from the previous one.