Re: Timer Events - newbie question

See the FAQ address below.
There is an article under the DBA
section, title:

    How can I schedule a particular piece of     code run at a regularly scheduled time ?

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Luch wrote in message ...


>I'd like to have a PL/SQL stored procedure on a timed event. Nothing fancy,

>something like

>

>my_proc {

>do stuff

>timer (500 seconds)

>}

>

>timer {

>post event my_proc()

>}

>

>Can anyone point me in the right direction to get me started. What I'm

>particularly not sure of is how to make it so the Procedure calls itself to

>start off whenever the database is restarted, and the correct way to use a

>timer with PL/SQL

>

>--

>Luch

>replace nospam with usa for e-mail.

>

>