Jobs schedule

Hello Forum Members
My Bo server has the following configuration

Bo Xi R3 - with Sp5
Clustered

Users schedule some jobs through application which need to run only once .
Once they schedule this it shows as a pending jobs until it recah a specific schedule time (This is normal behaviour).

My issue is if there as 100 pending jobs in the system scheduled by above application , if some users using infoview and select some report and click run now using the scheduler it also goes to pending job and it didnt run at all.

I check the Adapative job server setting , and I have 60 concurrent jobs.
is there is any setting I need to set to avoid this pending jobs (ie . Job click by user using info view as Run Now)

Regards
Repos


kksoft2002 (BOB member since 2009-12-10)

[Moderator note - moved to the CMC forum]Each job server has a limit on the number of concurrent jobs it can run. You can consider adding more job servers or increasing the limit. A more pragmatic approach would be to space out the schedules.


Nick Daniels :uk: (BOB member since 2002-08-15)

Another option might be to create a Job Server that only the account used by the Application has rights to and have the application specify this Job Server when the schedule is created. That would effectively create a queue for that set of scheduled reports. Then the User’s interactive schedules would use the normal queue. The two sets of scheduled reports shouldn’t conflict with each other then.


ChrisW1204 :us: (BOB member since 2011-04-21)

Good in theory, but I don’t believe it works in practice. We tried this with server groups in BI4, you can set it all up nicely in the CMC…but when the reports actually run they use whichever job server they please. That was server groups, I don’t believe it is any different for servers…we did raise it with SAP, they just said that is how it (doesn’t) work. I am pretty sure someone has created an idea for this on the ideas place.


Nick Daniels :uk: (BOB member since 2002-08-15)

Indeed someone has.


joepeters :us: (BOB member since 2002-08-29)

Ha! Good to see they acted on the information you provided. Oh wait, no, they didn’t. Hey, that was only four months ago what am I moaning about :hb:


Nick Daniels :uk: (BOB member since 2002-08-15)

At least I got a response within the first three years :roll_eyes:


joepeters :us: (BOB member since 2002-08-29)