Home » RDBMS Server » Server Administration » How to schedule a trigger
How to schedule a trigger [message #211532] Fri, 29 December 2006 04:24 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi

How to schedule a trigger, i need to fire the trigger every sunday.

Thanks
Re: How to schedule a trigger [message #211545 is a reply to message #211532] Fri, 29 December 2006 05:43 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It needs a triggering event to be fired. If you can schedule something (depending on kind of a trigger) to fire it, fine. If not, move trigger code to a PL/SQL procedure and schedule it (instead of a trigger).
Re: How to schedule a trigger [message #211580 is a reply to message #211545] Fri, 29 December 2006 11:42 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.com/node/862

http://www.orafaq.com/node/871

Previous Topic: Cloning Schema
Next Topic: 10G OEM Java Console.
Goto Forum:
  


Current Time: Sun Dec 04 16:48:06 CST 2016

Total time taken to generate the page: 0.11178 seconds