DBMS_Scheduler has scheduled a job with start date, but NO next run time
567616Nov 11 2010 — edited Nov 21 2010Hi there
I am having difficulty in geting a scheduled job to run at specified time as start_date from the query below,
select *
from dba_scheduler_jobs
where trunc(start_date) =trunc(sysdate)
It created using dbms_scheduler.create_schedule and create program , created a job.
the schdule also has got the calculated start_date which show correct start date and time , but the next run time is not populated from the result of the query.
**if I don't calculate the start_date , then the job run fine.** but if I do calculate the start date = sysdate + 3/24, then the job will be scheduled with no next_run_date populated , and the job wouldn't run.
The DB version is 10g
please help!