Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Timer Events - newbie question
that should do it... thanks guys.
-- Luch replace nospam with usa for e-mail. "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1007540632.17521.0.nnrp-01.9e984b29_at_news.demon.co.uk...Received on Sat Dec 08 2001 - 22:28:48 CST
>
> 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.
> >
> >
>
>
>