Timed code executions in MySQL?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kerunt
Forum Newbie
Posts: 2
Joined: Sat Feb 25, 2006 11:31 pm

Timed code executions in MySQL?

Post by kerunt »

Hello,

I need my code (PHP code which works with the MySQL database, processes info, and stores it back in the DB) to run every hour, and different code to run every 24 hours. What is the best way to achieve this? Is it possible to somehow store this code in the database itself and have it execute it?

The only way I can think of for solving this problem is writing an stand alone application (C#) to do what I need, and just keep it running 24/7 - but this isn't very convinient.

What's the best way to solve this problem?

Thanks!
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

cron or icron perhaps?
kerunt
Forum Newbie
Posts: 2
Joined: Sat Feb 25, 2006 11:31 pm

Post by kerunt »

Thanks for the tip.
Post Reply