Re: dbms_job jobs and resource consumer groups

You could use dbms application info package to set the module or action field and use that to map it into the right resource consumer group.

Allan

On Mon, Jul 7, 2008 at 5:38 PM, Dan Norris <dannorris_at_dannorris.com> wrote:

> I'm on 10.2.0.3, 3-node RAC (not that RAC matters in this case), RH4.
>
> I'm considering implementing resource consumer groups and having trouble
> finding any way to place a dbms_job into a particular consumer group. If my
> groups are mapped using the service_name that the user connected with, is
> there any way to assign a job to a particular consumer group? That is,
> without placing a call to DBMS_RESOURCE_MANAGER into the job? If I map the
> groups some other way (other than by username), is there a mapping that
> would handle all dbms_jobs easily?
>
> I know that migrating to DBMS_SCHEDULER is the "right" way forward, but
> that migration may take some time as the calls to DBMS_JOB are embedded in
> app code, so we're looking for a good interim solution.
>
> Thanks,
> Dan
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l