Re: How to implement time-based trigger in Oracle8 database?

From: Vrajesh Patel <vrajesh_p_at_hotmail.com>
Date: Fri, 23 Jul 1999 15:24:13 GMT
Message-ID: <xO%l3.84$%L2.11105@PM01NEWS>

Use Dbms_job to do so. Otherway, can use Unix Cronjob or NT job scheduler.

Thanks,

--
Vrajesh Patel

<dejasg_at_my-deja.com> wrote in message news: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:24:13 CDT