SEO

permalink · #1 (**permalink**) 02-26-2008, 07:40 AM

Hi,

Is it possible somehow to limit the number of job queue processes per
user? I would like to have user A to be able to have a maximum number
of 5 concurrent jobs and user B only 1 at a given time.

Regards,

Krisztian

permalink · #2 (**permalink**) 02-26-2008, 07:40 AM

On aug. 27, 18:20, prunoki <hegyv...@ardents.hu> wrote:
> Hi,
>
> Is it possible somehow to limit the number of job queue processes per
> user? I would like to have user A to be able to have a maximum number
> of 5 concurrent jobs and user B only 1 at a given time.
>
> Regards,
>
> Krisztian

By the way, it is 10.2.0.2 I am talking about. I see that I can do it
with dbms_scheduler, but can this be done with dbms_job?

K

permalink · #3 (**permalink**) 02-26-2008, 07:40 AM

prunoki wrote:

> On aug. 27, 18:20, prunoki <hegyv...@ardents.hu> wrote:
> > Hi,
> >
> > Is it possible somehow to limit the number of job queue processes
> > per user? I would like to have user A to be able to have a maximum
> > number of 5 concurrent jobs and user B only 1 at a given time.

Take a look here

http://www.adp-gmbh.ch/ora/sql/create_profile.html

Paul...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

number of job processes per user