Re: Can a Trigger run at a fixed time

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Mon, 08 Dec 2003 22:20:53 +0100
Message-ID: <koq9tv4sh1b0mirkrdgk1ra4b65vk4jgm5@4ax.com>

On 8 Dec 2003 12:50:37 -0800, green_24_at_hotmail.com (richard green) wrote:

>Hi,
> I want to do some insert/delete/update operations at 5 PM everyday.
>Is it possible to write a trigger that will do that. Or do I need to
>create a Stored Procedure which is invoked by a cron job?
>
>Thanx
>richard

You need to create a stored procedure which is invoked by Oracle's job facility, dbms_job

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 08 2003 - 15:20:53 CST