Stein, try dbms_jobs package provide by oracle(see pl/sql manual).
Ted Chyn
In article <776bp5$jng$1_at_romeo.dax.net>,
"Stein Andersen" <stein.andersen_at_c2i.net> 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.
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Jan 09 1999 - 09:36:53 CST
