Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timed Triggers

Status
Not open for further replies.
ameyrokde

ameyrokde

Programmer
Joined
Jul 5, 2001
Messages
1
Location
DE
Hi
I would like how can i write a trigger
which should be activated after specified time
and perform the specified activity
 
Sort by date Sort by votes
Use dbms_job...not a trigger.
A trigger causes something to happen based on another event occurring.

sounds like you are just wanting a process to occur on a timed basis...not based on another event occurring.
 
Upvote 0 Downvote
Check documentation on the DBMS_JOB package. This will run a stored procedure at a specified interval or time.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

nzcam
  • Locked
  • Question Question
Oracle Forms 3 (Forms triggers not executing)
Replies
1
Views
203
taupirho
taupirho
mikedaruke
  • Locked
  • Question Question
triggers on views
Replies
4
Views
247
Dagon
Dagon
eiram00
  • Locked
  • Question Question
Help with Triggers
Replies
5
Views
205
SantaMufasa
SantaMufasa
lizstanley
  • Locked
  • Question Question
oracle developer 6i triggers
Replies
2
Views
194
Toe
Toe
jasper04
  • Locked
  • Question Question
how to disable and enable triggers for schema user
Replies
2
Views
183
jasper04
jasper04

Part and Inventory Search

Sponsor

Back
Top