Re: Date triggered event (once a day)

Look at the package DBMS_JOB

You can create a db-job which will be executed in an intervall defined by you. This db-job can call any pl/sql-procedure

In the file config.ora the following values have to be set for job-execution:

job_queue_processes = 1 (the number of jobs which can be executed simultaneously, can be higher than 1)
job_queue_interval = 120 (every X seconds oracle does check whether a jobs has to be executed)

Regards, Stephan

Greg schrieb:

> Ineed a Function, procedure, trigger or what ever
> to trigger an envent based on the sys date.
> Means once a day like:
> check sysdate if sysdate is differnt then old sysdate
> do event.
>
> What (which tool) would be the best way to do it
> in a Oracle 8i NT environment.
>
> Setting up a scheduler who calls an SQL script?
>
> I'm thankful for any tips
> greg

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------