dba_scheduler issue
SQL> begin
dbms_scheduler.create_job(
job_name=>'SAMPLE_JOB',
job_type=>'EXECUTABLE',
job_action=>'/u000/app/oracle/rman/test.ksh',
start_date=> '27/AUG/2009 10:17:45 AM',
repeat_interval =>'FREQ=HOURLY;INTERVAL=2',
enabled => true,
auto_drop=>false,
comments => 'sample job'
);
END;
/
PL/SQL procedure successfully completed.
select * from dba_scheduler_jobs where job_name='SAMPLE_JOB';
JOB_NAME JOB_ACTION START_DATE NEXT_RUN_DATE
-------------------- ------------------------------------ ----------------------------------- -------------------------------------------------
SAMPLE_JOB /u000/app/oracle/rman/test.ksh 27-AUG-09 10.17.45.000000 AM -04:00 27-AUG-09 10.17.45.000000 AM -04:00
At 10:30 AM, I see the job is not executed as below. What might be the issue