Re: Can a Trigger run at a fixed time

From: Sean Chang <sean_at_cnfei.com>
Date: Wed, 10 Dec 2003 08:51:19 -0500
Message-ID: <3fd724d7$1_3@corp.newsgroups.com>

I'm sorry I misunderstood the original post.

You are right, I believe using scheduling is the easiest way to achieve what the OP wants.

sean chang

> Maybe I'm having a mental lapse here, but isn't a trigger fired by an
> EVENT? I fail to see how it is reliable to have your trigger fire at
> specific times, if there is no event to cause the trigger to fire in the
> first place.
>
> That being said, it makes sense to just schedule these actions to occur
> at your desired point(s) in time using a SP and dbms_job.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Wed Dec 10 2003 - 07:51:19 CST