Re: Executing a store procedure every 2 hours
From: Birger Johansson <birger.johansson_at_ibitec.se>
Date: Wed, 03 Nov 1999 20:32:27 GMT
Message-ID: <7vq64s$cvk$1_at_nnrp1.deja.com>
Date: Wed, 03 Nov 1999 20:32:27 GMT
Message-ID: <7vq64s$cvk$1_at_nnrp1.deja.com>
Hi 'golden_hair'!
Why not use the operating system's features for this kind of task? If your Oracle is on some sort of UNIX you can probably use crontab.
/Birger Johansson
In article <7vq3q8$avq$1_at_nnrp1.deja.com>,
golden_hair_at_my-deja.com wrote:
> Hi everyone!
>
> I need to execute a stored procedure in
> oracle 8.0 every two hours.
> How can I do that?
> I think DBMS_ALERT is useless for this purpose.
>
> Thanks a lot for your ideas !
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
-- --------------------------------------------- Birger Johansson Ibitec Datakonsult AB www.ibitec.se --------------------------------------------- Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Nov 03 1999 - 21:32:27 CET