DBMS_SCHEDULER ORA-27476
Hi folks,
I am experimenting with new DBMS_SCHEDULER feature in Oracle 10g for scheduling jobs to run Unix commands such as top, iostat, etc.
Anyways, I would appreciate your help on a problem that I am currently facing.
I have created the following job in Oracle 10g Release 1 on Unix:
SQL> begin
2 dbms_scheduler.create_job(
3 job_name=>'runtop',
4 job_type=>'executable',
5 job_action=>'/Users/oracle/runtop.ksh',
6 enabled=>true,
7 auto_drop=>true
8 );
9 end;
10 /
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_scheduler.run_job
3 (job_name=>'runtop');
4 end;
5 /
begin
*
ERROR at line 1:
ORA-27476: "SCOTT.RUNTOP" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 2
Why does it complain that it cannot find my job? Thanks
Ben Prusinski, Oracle DBA