Re: jobs scheduled but it will not run.

"Snewber" <s_z_at_zz.com> wrote in message news:<cilsmb$gs1$1_at_bunyip.cc.uq.edu.au>...
> Run this query and look at VALUE.
>
> select * from v$parameter where name ='job_queue_processes' order by 2 ;
>
>
> "Andre" <avanrossem_at_hotmail.com> wrote in message
> news:4d32d1be.0409192130.96a85fc_at_posting.google.com...
> | Hello all,
> |
> | I have an (oracle 8.1.7.) problem.
> | I created a job using:
> |
> | variable jobno number;
> | begin
> | dbms_job.submit (:jobno, 'pckserver.timer;', trunc(sysdate + 1) +
> | 22/24,
> | 'trunc(sysdate + 1) + 22/24');
> | commit;
> | end;
> |
> | So every evening at 22:00 hours it must be executed.
> | initially the next-date and the interval are not filled in, but when I
> | manually start the job using the "exec dbms_job.run(29)"; command it
> | does.
> | Below you can see the select on the jobs which are scheduled:
> | (I manually started the job at 17/9/2004 at 8:41:27)
> |
> | LOG_USER Job B fail LastDate ThisDate nextDate
> | runInterval WHAT
> | ---------- -------- - ---- ------------------ ------------------
> | --------------PIPO 29 N 0 17-09-04:08:41:27 :
> | 18-09-04:22:00:00 1.555 pckserver.timer;
> |
> | But When I view the jobs on the 19th of September nothing was done. I
> | get the same result as above! Why is this job not running?
> |
> | pckserver.timer is a working procedure (I can start it manually).
> |
> | Any help would be really appreciated.
> |
> | Regards,
> | Anneke

That was indeed the problem!!

I configured this to a number 8 and all is working. Thanks al lot!!,
Anneke Received on Tue Sep 21 2004 - 00:50:37 CDT