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!

Error In Running dbms_scheduler.run_job ORA-27369.

842883May 24 2011 — edited Jun 17 2011
Dear Sir
I am trying to execute one batch file from one schedule which imports the data using imp command now my files look like this

*****************imp.bat ***************

imp treasury/tisnic@orcl FILE="C:\data\gis031164.dmp" LOG="C:\data\imp_gis031164.log" FULL=Y IGNORE=Y FEEDBACK=1000

*********************job created with bellow code *******************************

begin
DBMS_SCHEDULER.CREATE_JOB (
job_name=> 'myjob',
job_type=> 'EXECUTABLE',
job_action=> 'c:\windows\system32\cmd.exe /c c:\imp.bat',
enabled=> TRUE,
auto_drop=>false,
start_date => sysdate + 9999
);
commit;
end;

******************************

now when i run my job with bellow command

begin
dbms_scheduler.run_job('myjob');
end;

it gives me error as follow

ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 2


kindlly help as i have tried all your solutions in so many threads but same issue not finding any solution for my problem


Thanks & Regards
Aashish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2011
Added on May 24 2011
15 comments
4,041 views