Re: Date triggered event (once a day)
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/12
Message-ID: <958112393.15065.0.pluto.d4ee154e_at_news.demon.nl>#1/1
Date: 2000/05/12
Message-ID: <958112393.15065.0.pluto.d4ee154e_at_news.demon.nl>#1/1
Use the dbms_job facility.
Runs pl/sql procedures at user-specified intervals.
Hth,
Sybrand Bakker, Oracle DBA
Greg <actiris_at_loxinfo.co.th> schreef in berichtnieuws
391B8F64.722F2427_at_loxinfo.co.th...
> 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
>
Received on Fri May 12 2000 - 00:00:00 CEST