Help for scheduling a job
Hi,
I've just created a job by using this:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'SCHED_CALENDARIO',
job_type => 'STORED_PROCEDURE',
job_action => 'PRC_INS_CALENDARIO_CONSUNTIVO',
repeat_interval => 'FREQ=MINUTELY;BYHOUR=00;BYMINUTE=10',
enabled => TRUE,
comments => 'Carica su TIMESHEET_CONSUNTIVO il calendario ad ogni inizio mese');
END;
/
After launching the job, I've looked here:
select JOB_NAME, STATE, NEXT_RUN_DATE
from user_scheduler_jobs
and I got:
JOB_NAME STATE NEXT_RUN_DATE
SCHED_CALENDARIO SCHEDULED *05-JUN-13 12.10*.12.900000 AM AMERICA/CHICAGO
Why doesn't the job seem to be schedulated with 10 minutes from now (today is June 4th) but for tomorrow?
Having set FREQ=MINUTELY;BYHOUR=00;BYMINUTE=10 I thought the job would start by 10 minutes from now and today and not tomorrow.
Thanks