var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: scheduler daily from starting now
i have below scheduler code written on oracle 10g to run.
scheduler is calling a procedure test1() just makes an entry to table.
start_date => SYSDATE,
repeat_interval => 'FREQ=DAILY;INTERVAL=1;BYHOUR=0;BYMINUTE=0;BYSECOND=0',
enabled => TRUE
i want to run the scheduler now (i.e first time should be fired time) and daily morning 12:00 AM.
so i have written the above code, after i run the scheduler successfully.
i tested in the table which does not make any entry into it, this means it is not runned for the first time.
Run this sql and review entries to validate job setup correctly:
select * from sys.dba_jobs
i am using this sql query to check
SELECT job_name, enabled, NEXT_RUN_DATE FROM USER_scheduler_jobs;
Did you commit after entering the scheduler job?
You do not need a parachute to skydive. You only need a parachute to skydive twice.
i tested with commit. No luck.
As per my understanding start_date is to mention from which time stamp the scheduler should active, it is not the first running time. Based on the interval it is runs first execution also.
any way for how to run scheduler first when i was fired and then next time is the every day change (i.e 12:00 AM)..?
Well, if you leave both START_DATE and REPEAT_INTERVAL NULL, it will be executed immediately. Though, no scheduling in this case.
Therefore, perhaps you should do that in two steps: first, run the procedure - it will do the initial insert. Second, schedule a job. (Don't forget to COMMIT). It will run tomorrow and the days that follow.
Tags for this Thread