Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: automatically execute procedure in certain time
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
--