Re: Can a Trigger run at a fixed time

From: Sean Chang <sean_at_cnfei.com>
Date: Tue, 9 Dec 2003 16:45:17 -0500
Message-ID: <3fd6426e$1_3@corp.newsgroups.com>

How about put the time condition inside the trigger code, like

create or replace trigger My_trigger

     after insert or delete or update of My_table
            for each row
      when (to_number(to_char(sysdate, 'HH24') ) not between 8 and 17)

  begin

---do somthing here
end;

"richard green" <green_24_at_hotmail.com> wrote in message news:811617d5.0312081250.67ca893_at_posting.google.com...
> 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

-----= 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 Tue Dec 09 2003 - 15:45:17 CST