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

Question

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

a producer is a person and execute also means murder. i fixed your spelling though so it doesn't look like you're trying too kill people. — I wrestled a bear once., Oct 04 '15 at 13:10

score 4 · Accepted Answer · edited May 23 '17 at 12:22

4

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"

edited May 23 '17 at 12:22

Community

1
1

answered Oct 04 '15 at 13:09

Marmite Bomber

19,886
4
26
53

Thanks so much This Helped a lot one more thing can you tell me how to monitor it if it run successful or not and why – alaadin ibrahim Oct 04 '15 at 15:35
Have a look at the system views that show the status of the scheduled job, and its execution history. You can also use scheduler chains to get custom actions (such as sending an email) when a job completes successfully or unsuccessfully. – David Aldridge Oct 04 '15 at 16:10

score 1 · Answer 2 · answered Oct 05 '15 at 06:23

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.
:)

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

2 Answers2