This discussion is archived
7 Replies Latest reply: Jan 5, 2013 4:15 AM by Ayham RSS

DBMS_SCHEDULER.CREATE_JOB !!!

Ayham Newbie
Currently Being Moderated
Hi all,
i have facinf this problem with DBMS_SCHEDULER.CREATE_JOB.

i am using windows 7 and oracle 11g r2 .

used this code to run batch file.
BEGIN  
   DBMS_SCHEDULER.CREATE_JOB (  
    job_name   => 'myjob',  
    job_type   => 'EXECUTABLE',  
    job_action  => 'c:\a.bat',  
    enabled   => false);  
 END; 
the i call it
EXEC  DBMS_SCHEDULER.RUN_JOB ('myjob');
or by this
DBMS_SCHEDULER.RUN_JOB ('myjob');
but this probelm occured
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1
FYI:
I also run the service that called
OracleJObSCHEDULER from windows service.

Is there any idea to solve this probelm?.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points