Skip to main content

Only 2 Jobs Running at a time

I noticed while executing a document with four underlying reports that only 2 reports were executing at a time. There was no reason that the server cannot handle more than 2 jobs at a time.

Think of this scenario - there are 50 users in your organization who need to run report. If only 2 jobs execute at a time on iserver, it while be a while before all users get their data!

Here's how to change that:

  1. Right click on project
  2. Go to Project Configuration
  3. Go to Database Instances > Select your DB provider
  4. Select Database Instance and click Modify button
  5. Go to Job Prioritization tab
  6. On the bottom change the number of simultaneous jobs that can be executed

Consult your system administrator for any 'side effects'. I work with 9.3 version.

Comments

There are likely a million reasons why you could need to attempt and find what job(s) may have been running at a specific time. The majority of them, obviously, will be because of different execution issues, symptoms, and different issues that you may wind up seeing on one of your servers at a given time—and being able to rapidly discount a SQL Server Agent Job (or realize that it was the guilty party) is in this manner, a gift from heaven
Anonymous said…
This comment has been removed by the author.