Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do automatic Periodic Maintenance with triggers/procedures ?
There is dbms_job package which you can use if two parameters are set:
job_queue_processes = 1
job_queue_interval = <time interval job will be executed>
Stein Andersen пишет в сообщении <776bp5$jng$1_at_romeo.dax.net> ...
>Concerning Oracle Server 7.3.x and 7.2.x on Windows NT (and UNIX),
>
>In a database I am setting up, I have the need to execute some SQL with
>certains intervalls (a few hours). I am currently using an at-command
>in Windows-NT/Unix to insert a row in a tabel, and as a result of that a
>trigger
>which does the actual job is fired.
>
>Does anybody know about a way in the basic server-installation for 7.2/7.3
>to
>execute a trigger or procedure on a given time, or with regular intervalls.
>
>
>
Received on Sat Jan 09 1999 - 15:06:19 CST