Re: can we program 'Timer' with PL/SQL ?

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Fri, 28 May 1999 09:13:26 +0100
Message-ID: <374e4de3.0@145.227.194.253>

dbms_job(job_number, procedure, date of run, time interval);

e.g

dbms_job(1,'a(????)', sysdate , sysdate * 1/24)

Look at documentation, you may not need the interval if it is a one off job.

Mark

Wassim wrote in message <7ijoho$qcu$1_at_nnrp1.deja.com>...
>
>> You may want to use DBMS_JOB to run the function say 5 mins after
submitting
>> the job?
>>
>> Mark
>
>assuming my procedure is called a(), what is the syntax for telling oracle
>execute a() after 5 minutes from now ! using isubmit of course? thanks.
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Fri May 28 1999 - 03:13:26 CDT