CODEWITHSUNDEEP
sqloracle-databaseplsqltriggersprocedures
alaadin ibrahim
alaadin ibrahim

Reputation: 23

How to create a trigger to run a procedure at a certain time?

I need to know if there is any way to create trigger to execute procedure on certain time like :

create trigger Fire 
when sysdate = 1-oct-2015 
execute (procedure);

I hope you understand me and please provide any solution how I can do it

Upvotes: 1

Views: 10771

Answers (2)

Avrajit Roy
Avrajit Roy

Reputation: 3303

There are various ways to schedule a PROCEDURE/FUNCTION. Below are the mentioned ways you can do it.

1) There is DB scheduler.
2) There is CRON TAB.
3) There is AUTOSYS jobs.
4) Datawarehousing tools like ETL (Informatica etc.)

These are very eficient to handle these kind of scheduling. My personal favourite id AUTOSYS jobs which uses.JIL file.
Let me know if this helps you.
:)

Upvotes: 1

Marmite Bomber
Marmite Bomber

Reputation: 21075

Trigger is executed BEFORE or AFTER some event e.g. INSERT. To control execution at a specific time maybe you need a SCHEDULER

Simple example is here other search with "DBMS_SCHEDULER"

Upvotes: 4

Related Questions