dbms_scheduler job not started at start date
Hi ,
I have an issue I am trying to schedule a job monthly starting from today.
But job is not starting at start date instead its starting on next_run_date.
suppose now the time 6 : 08 and i create this to start at 6 :10 and repeat every month .,i give the following code
but its not starting at the start date specified.Please help me
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'load_data',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN PRC_INS_TOTAL_HOURS_EMPLOYEES; END;',
start_date => to_date('09-OCT-2009 06:10:00 PM','DD-MON-YYYY HH:MI:SS PM'),
repeat_interval => 'FREQ=MONTHLY;BYMONTHDAY=9;BYHOUR=18',
enabled=> true,
comments => 'Job defined to execute a procedure that loads data into DB.');
END;
a query on user_scheduler_jobs shows
JOB_NAME start_date next_run_date
LOAD_DATA 09-OCT-09 06.10.00 PM +05:30 09-NOV-09 06.10.00.300000000 PM
at 6:13 when i see the job has not run at 6:10.Please correct if my understanding is wrong . i am using the scheduler first time.
thanks in advance
Please help.