Database Administration (MOSC)

MOSC Banner

Is there a way to allow limiting number of running scheduler jobs per pool?

edited Dec 30, 2009 11:08PM in Database Administration (MOSC) 1 commentAnswered
Is there a way to allow limiting number of running scheduler jobs per pool?
Let's say we have N entities which need to be processed by some Oracle procedure. Processing them one by one would be too slow. Processing all of them in parallel (e.g. spawn scheduler jobs for each entity) - could demand too much resources and overload the system. So what we'd like is to be able to say that we want all these N jobs (one for each entity) to run in such a way that just M (usually M<=N) of them to be running (others are waiting).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center