Re: Oracle Timer?
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 07 Aug 2001 18:53:30 +0100
Message-ID: <3B702B1A.5E1E_at_yahoo.com>
Date: Tue, 07 Aug 2001 18:53:30 +0100
Message-ID: <3B702B1A.5E1E_at_yahoo.com>
Matt Flavin wrote:
>
> Is am new to Oracle, and need a way to execute a procedure in Oracle on
> a fixed time interval. Does the WHEN-TIMER-EXPIRED trigger only apply
> to Oracle Forms, or can this be used anywhere?
>
> Thanks in advance for any information
>
> Matt Flavin
All you need is DBMS_JOB
See www.jlcomp.demon.co.uk/faq/dbms_job.html
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Tue Aug 07 2001 - 19:53:30 CEST