7 Replies Latest reply: Jan 5, 2013 6:15 AM by Ayham RSS

    DBMS_SCHEDULER.CREATE_JOB !!!

    Ayham
      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?.