2 Replies Latest reply: Mar 16, 2008 2:13 AM by Sabdar Syed RSS

    dbms_scheduler question

    551892
      Hi

      I logged in as schema_user@dbname and trying to use dbms_scheduler package.
      I throws me error
      BEGIN
      *
      ERROR at line 1:
      ORA-27486: insufficient privileges
      ORA-06512: at "SYS.DBMS_ISCHED", line 99
      ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
      ORA-06512: at line 3

      Ok my question is can't a user schedule a job.And what privelege do the schema_user need for submitting the job is it "create any job"
        • 1. Re: dbms_scheduler question
          MaximDemenko
          Scheduler jobs are schema objects. To create jobs in own schema CREATE JOB is sufficient, CREATE ANY JOB allows to create the scheduler jobs in another schemas.
          Fortunately, you can read about it (and many other useful things) in the provided [url http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1000363]documentation

          Best regards

          Maxim
          • 2. Re: dbms_scheduler question
            Sabdar Syed
            ERROR at line 1:
            ORA-27486: insufficient privileges
            ORA-06512: at "SYS.DBMS_ISCHED", line 99
            ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
            ORA-06512: at line 3


            The user has got NO privileges to run the jobs. User has to have to proper privileges to run the jobs, so grant the CREATE JOB or CREATE ANY JOB privilege.

            SQL> conn /as sysdba
            SQL> GRANT create any job TO schema_user;

            Read the document referred by Maxima for more information on Schedulers/Jobs.

            Regards,
            Sabdar Syed.