Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Job
I have 8.05 on NT and problem are job queues.
I created job and next i can run this job but consecutive job it isn`t run
in periodic time.
A long time it was OK. I don`t know what happend.
Can you help my anyone?
Thanks.
Table user_jobs:
last_date next_date broken failures 25.4.2000 10:49:36 25.4.2000 12:49:36 N 0
command for job:
variable jobno number;
begin
DBMS_JOB.SUBMIT(:jobno
,'pc_mnozstv.i(0,0,1,null);'
, SYSDATE
,'SYSDATE + 1/12');