How To Handle Recurring Actions

Hi!


My problem/"goal to achieve" is the following..


Users can insert orders in a db-table. The date on which they've been created is stored.


I want the server to insert a new record in another table (accounts) for every order which is older than 2 weeks.


How should I do that?


With a custom action which checks all orders (a customer must press some button every day).


Or a static "update-class" with a kind of timer which does the action every 24 hours?


Of course an automatic solution will be the best! Another question is: how can i ensure that an instance of this "update-class" will never die?


Thanks so far...