Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER.CREATE_JOB !!!

AyhamJan 5 2013 — edited Jan 5 2013
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?.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2013
Added on Jan 5 2013
7 comments
902 views