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