Job wont run at scheduled time

Oracle 9.2.0.6 on Solaris 64
I've created theses jobs to replicate data,  and they appear to just sit there.
job_queue_processes is set to 10
job_queue_interval is not set as it is deprecated in 9i

Select
job,schema_user,last_date,next_date,total_time,broken,failures,interval,what   from user_jobs where job=2;

JOB        :2
SCHEMA_USER:REPADMIN
LAST_DATE  :05/05-14:44:22
NEXT_DATE  :05/05-15:15:00
TOTAL_TIME :0
Broken     :N
FAILURES   :0
INTERVAL   :trunc(sysdate+(1/24),'HH24')+15/(60*24)
WHAT       :dbms_refresh.refresh('"REPADMIN"."EVOL_GRP2"');

15:15 comes and goes, and the job just sits there...?

When doing "exec dbms_job.run(2);"
the job appears to run fine, with last date showing the current time and next_date showing 15 minutes past the hour, next hour.

I can also execute dbms_refresh.refresh('"REPADMIN"."EVOL_GRP2"') in SQLPlus, without generating any errors.

The problem is several hours later,
the job still shows up with the same LAST_DATE and NEXT_DATE.

I've even altered job_queue_processes to 0, and then back to 10 (after a few minutes, as per bug 2649244)

Or should I just give up and use a cron jobs.

TIA
Guy. Received on Fri May 06 2005 - 10:13:42 CDT