Incorrect start time
VVAug 15 2007 — edited Sep 6 2007Hi,
I have a scheduler which runs a procedure every day at 9am. The code looks like this:
BEGIN
DBMS_SCHEDULER.CREATE_JOB(JOB_NAME => 'my_job_scheduler,
JOB_TYPE => 'STORED_PROCEDURE',
JOB_ACTION => 'my_procedure',
START_DATE => SYSTIMESTAMP,
REPEAT_INTERVAL => 'FREQ=DAILY; BYHOUR=9',
ENABLED => TRUE,
AUTO_DROP => TRUE,
);
END;
The job runs successfully and each time it takes about 3 seconds.
However, when I look in the dba_scheduler_jobs table, the last run date and start run date is at 9.11 everyday and not 9.00.
Any idea why that is?
Thanks
Venus