I have a group of reports, about 9 or 10 that need to be run from the hub on an AdHoc basis. They include sales data and vary in data to be processes month by month.

If you run all the reports at the same time, it takes longer than runnning them individually due to the strain on the server resources. So, I want to set them all running, but they run concurrently when you do this from the Hub and try to process at the same time causing resource issues and they all slow down.

If I plan them, I have to leave in so much space incase of large data (December sales are big, Jan sales are small hence December run needs more time than Jan) that I'm wasting a lot of time. I simply want to queue the jobs and run them one after the other - then it doesn't matter how long one job takes, I don't have to run them all one at a time to get the timings right (since they change month on month, this is awkward anyway), I can just queue the batch up, they run sequenially.