I created a job in the DBMS_SCHEDULER with the following code -
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'POSPAY_CHECK_JOB',
job_type => 'EXECUTABLE',
job_action => '/dev/POSPAY_USC2_CHECK.sh',
auto_drop => FALSE,
enabled => TRUE);
END;
/
When I tried to run the job, I got this error -
"ORA-27369: job of type EXECUTABLE failed with exit code: 255 STANDARD_ERROR="execve: No such file or directory""
After reviewing the job in the dba_scheduler_jobs view, I noticed that ENABLE = FALSE. When I ran the code to enable it, it STILL remained FALSE.
BEGIN
DBMS_SCHEDULER.ENABLE('POSPAY_CHECK_JOB');
END;
/
Can someone please let me know why the new job will not run?
Why can't I ENABLE it?
Thanks!