Re: automatically execute procedure in certain time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 Feb 2000 12:48:14 +0100
Message-ID: <950270792.17086.2.pluto.d4ee154e@news.demon.nl>

use the dbms_job package.

Hth,

Sybrand Bakker, Oracle DBA

<kolackova_at_scio.cz> wrote in message news:880np1$uev$1_at_nnrp1.deja.com...
> Hi,
>
> I need automatically execute a stored procedure in a certain time in
> the night.
> This procedure updates records in one table which is depending on
> other tables. We don't want to execute this procedure every time, when
> related records are inserted or updated because this procedure is
> more complicated and it could blockade some other processes.
>
> Is it possible to write a script that would execute that procedure
> in a certain night time?
>
> Thanks for any advise.
> Jana
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 11 2000 - 05:48:14 CST