Re: Date triggered event (once a day)
From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/12
Message-ID: <gtRS4.186573$Tn4.1478760_at_news1.rdc2.pa.home.com>#1/1
Date: 2000/05/12
Message-ID: <gtRS4.186573$Tn4.1478760_at_news1.rdc2.pa.home.com>#1/1
You can also use the at scheduler in NT.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "Greg" <actiris_at_loxinfo.co.th> wrote in message news:391B8F64.722F2427_at_loxinfo.co.th...Received on Fri May 12 2000 - 00:00:00 CEST
> 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
>