0

How can I create trigger for table to insert a row every 30 day?

ID  Date        Days
1   10/7/2016    0
2   09/8/2016    30  
3   08/9/2016    60
1

1 Answer 1

2

A trigger is executed as result of a certain event (e.g insert/update/delete on a table). You need something like a job scheduler.

You did not specified the database. By example Oracle has something like:

DBMS_SCHEDULER.CREATE_JOB(....

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.