Re: automatically execute procedure in certain time

A copy of this was sent to kolackova_at_scio.cz (if that email address didn't require changing) On Fri, 11 Feb 2000 10:20:19 GMT, you 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
>

See the package DBMS_JOB.

For a quick overview of it, run:

  1 select text
  2 from all_source
  3 where name = 'DBMS_JOB'
  4 and type = 'PACKAGE'
  5* order by line
SQL> /
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Feb 11 2000 - 06:20:43 CST