Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: automatically execute procedure in certain time

Re: automatically execute procedure in certain time

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 11 Feb 2000 20:27:33 +0800
Message-ID: <38A40035.640C@yahoo.com>


kolackova_at_scio.cz wrote:
>
> 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.

See the other two posts and don't forget to commit when you submit your job - otherwise it won't run.

HTH
--



Connor McDonald
There are 3,434,679 oracle websites around the world. Now there is one more... http://www.oracledba.co.uk Received on Fri Feb 11 2000 - 06:27:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US