Re: Job wont run at scheduled time

"G Quesnel" <dbaguy_ott_at_yahoo.com> wrote in news:1115392422.440596.97460_at_f14g2000cwb.googlegroups.com:

> 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.
>
>

After "submitting" the job request, did you ever issue a "COMMIT"? Received on Fri May 06 2005 - 10:16:15 CDT