Re: Simple timer question by a newbie
From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 22 Jan 2002 17:22:20 -0000
Message-ID: <a2k75v$3kr$1_at_thorium.cix.co.uk>
Date: Tue, 22 Jan 2002 17:22:20 -0000
Message-ID: <a2k75v$3kr$1_at_thorium.cix.co.uk>
Hi
Check out the DBMS_JOB procedure, it does exactly as you want. You need to check that job_queue_interval and job_queue_processes are set in your init.ora file.
Alistair
"PG" <realAddress_at_inmsg.com> wrote in message
news:3C4D9ED6.50804_at_inmsg.com...
> Hi oracle gurus,
>
> i have a procedure that loads some data from a file and puts it in a
> table. I would like to trigger this procedure repeatedly after a certain
> duration. I want to use just oracle (no java/ c++/ vb etc). Is there a
> standard timer in oracle? (some kind of sleep/ wait mechanism?)
>
> I am using Oracle 8.1.7.
>
> Thanks a lot in advance.
>
> PG
>
Received on Tue Jan 22 2002 - 18:22:20 CET