This content has been marked as final. Show 2 replies
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
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.