Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Job

Oracle Job

From: tony <bobek_at_ba.ttc.sk>
Date: 2000/04/27
Message-ID: <956834361.356802@virtual.nextra.sk>#1/1

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');

 commit;
end;
/ Received on Thu Apr 27 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US