4 Replies Latest reply on Aug 3, 2012 6:37 AM by Mustafa KALAYCI

    How to enforce JOB_CLASS while DBMS_SCHEDULER.CREATE_JOB ?

    J-Oracle
      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