Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to enforce JOB_CLASS while DBMS_SCHEDULER.CREATE_JOB ?

jojacob-OracleAug 2 2012 — edited Aug 3 2012

All,

Env: 11gR2 on Linux

All my users/(schemas) can schedule jobs using DBMS_SCHEDULER.

I have a resource_cosumer_group called SCHEDULER_GROUP (->SCHEDULER_CLASS)

How do i "enforce" them to use a particular JOB_CLASS in the dbms_scheduler.create_job ?

ie: SCHEDULER_CLASS

If left blank, the default is DEFAULT_JOB_CLASS and i do not want to set limits on this as this is being used by SYS jobs too.

TIA,
JJ

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2012

Added on Aug 2 2012

#database-key-features, #scheduler

4 comments

957 views