Re: Executing a store procedure every 2 hours
From: Stephan Born <stephan.born_at_beusen.de>
Date: Thu, 04 Nov 1999 13:24:11 +0100
Message-ID: <38217AEB.151EC50E_at_beusen.de>
Date: Thu, 04 Nov 1999 13:24:11 +0100
Message-ID: <38217AEB.151EC50E_at_beusen.de>
> 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.
>
Right!
Try dbms_job....
Regards, Stephan
--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born | beusen Consulting GmbH
fon: +49 30 549932-0 | Landsberger Allee 392
fax: +49 30 549932-29 | 12681 Berlin
mailto:stephan.born_at_beusen.de | Germany
---------------------------------------------------------------
PGP-Key verfügbar | PGP-Key available
---------------------------------------------------------------
Received on Thu Nov 04 1999 - 13:24:11 CET