Timer Events - newbie question 
Author Message
 Timer Events - newbie question
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)

Quote:
}

timer {
post event my_proc()

Quote:
}

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.



Sun, 23 May 2004 09:59:56 GMT
 Timer Events - newbie question

You can use the dbms_job package to run a pl/sql program at intervals.
Jim

Quote:
> 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.



Sun, 23 May 2004 10:04:58 GMT
 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.

Quote:

>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.



Sun, 23 May 2004 16:25:39 GMT
 Timer Events - newbie question
that should do it... thanks guys.
--
Luch
replace nospam with usa for e-mail.


Quote:

> 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.


> >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.



Thu, 27 May 2004 12:28:48 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Simple timer question by a newbie

2. Timer's Event

3. Time based events (Timer)

4. timer event Problem

5. time - timer events

6. DDE-doc's & Timer-event

7. Pdox 9 - Where has my Timer Event gone?

8. Setting timer events and starting the clock

9. Close form with timer event /no keyboard activity

10. Visual Foxpro and timer events

11. Foxpro native event timer


 
Powered by phpBB® Forum Software