Schedule a job to run every second, how

From: <ptsao_at_sequeltech.com>
Date: 1997/01/08
Message-ID: <32D3D7FD.151D_at_sequeltech.com>#1/1


We are on Workgrop Oracle server 7.3/NT 4.0.

I did the following to schedule a job to run for every second but it runs every minute instead. I changed the job_queue_interval values from the default 60 to 1 and restarted the server but did not seem to change anything. What happened? Thanks.

variable jobnum number
begin
  dbms_jo.submit(:jobnum,'insert into test values(1,sysdate);',

                  sysdate,'sysdate+1/86400');
end; Received on Wed Jan 08 1997 - 00:00:00 CET

Original text of this message