Home Forums Reporting Services Reporting Services Eliminate report server subscriptions from showing in SQL Agent job list RE: Eliminate report server subscriptions from showing in SQL Agent job list

  • Jack Corbett (12/10/2014)


    ... The other issue is that with each an individual job they run in parallel, at least the AddEvent SP is run in parallel, whereas putting them in one job serializes them.

    Thanks for the feedback.

    I think I see what you're saying. 40 individual schedules running 40 reports at exactly 7:00:00am is better than 1 schedule running 40 reports in series (7:00:01, 7:00:03, 7:00:05, etc)? For background, the 40 jobs are actually 4 very different reports, going out to 10 users at the same time. You're suggesting by serializing them with the same Agent schedule (a single GUID job listed in SQL Agent) they're going to run slower than if they all fired at exactly 7:00 where they'd possibly utilize SQL Server's parallel query capabilities? Am I understanding?

    Truth be told, I'm in a very small office environment so I'm rarely worried about off-hours query execution speed but I'm truly trying to understand what you mean here.