Re: HELP: dbms.job - scheduling job at exact time

mvapenik_at_cz.soluziona.com (Milan) wrote in message news:<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
> l_job number;
> begin
> dbms_job.submit( l_job,
> 'test_proc;',
> sysdate,
> 'sysdate+1/1440' );

sysdate + 60/86400 will restart at 60 second intervals. (86400 is total number of seconds in 24 hours)

Regards
/Rauf Sarwar Received on Wed Jun 25 2003 - 21:28:45 CEST