Error In Running dbms_scheduler.run_job ORA-27369.
842883May 24 2011 — edited Jun 17 2011Dear 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