HELP: dbms.job - scheduling job at exact time
From: Milan <mvapenik_at_cz.soluziona.com>
Date: 25 Jun 2003 01:12:14 -0700
Message-ID: <207c3ce7.0306250012.285d2855_at_posting.google.com>
end;
Date: 25 Jun 2003 01:12:14 -0700
Message-ID: <207c3ce7.0306250012.285d2855_at_posting.google.com>
Please, has anyone an idea about planning job in axact time ? I mean
we need to run job in every minute starting at 00 sec. This job takes
about 2 secs and call another stored procedure.
I wrote this pl/sql block:
declare
dbms_job.submit( l_job,
'test_proc;',
l_job number;
begin
sysdate,
'sysdate+1/1440' );
commit;
end;
Everything is fine except of submit time. I have no idea about telling Oracle to run this job every minute at 00 sec.
Thanks Received on Wed Jun 25 2003 - 10:12:14 CEST