You can schedule jobs. Take a look at the dbms_job package.
--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
dejasg_at_my-deja.com wrote in message <7n8kea$bnu$1_at_nnrp1.deja.com>...
>Hi,
>
> I will appreciate it if you can tell me how can I have a
>trigger process that is activated at regular time interval (let say
>every day at midnight) to do some checking and updating to tables in
>Oracle8 database. Do I use database triggers or does Oracle8 provides
>other ways in achieving similar job process?
>
> Thank you.
>
>Cheers,
>Koot Sung
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 10:13:50 CDT
