| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 ?
Stein Andersen wrote:
>
> 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.
Look at the other posts about DBMS_JOB....Worthy of note is that after you submit a job - it only becomes active after a COMMIT
Cheers
--
 |
 |