ORA-27369: job of type EXECUTABLE failed with exit code: No such file or di
629628Apr 27 2011 — edited Sep 23 2011I am receiving the error "ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory" when trying to run a job.
begin
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'BrianTest',
job_type => 'EXECUTABLE',
job_action => '/usr/bin/ksh /u01/appfiles/billdev/bhjob.ksh',
repeat_interval => 'FREQ=YEARLY',
enabled => TRUE
);
dbms_scheduler.run_job('BrianTest');
end;
Results:
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 12
My executable (/u01/appfiles/billdev/bhjob.ksh) is very basic.
/bin/echo BHTEST >> /u01/appfiles/billdev/bh.txt