Jump to content

Archived

This topic is now archived and is closed to further replies.

kerunt

Timed code executions in MySQL?

Recommended Posts

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!

Share this post


Link to post
Share on other sites
Generally you set up a cron job, but that's on linux. On WinXP it'd be the scheduler or something.

I always write my cron jobs in Perl, I don't know anything about PHP on the command line.

Share this post


Link to post
Share on other sites
Agreed -- although the new release of MySQL (5.1.6, I believe) has a scheduler that should make it into a GA version soon enough. But cron in the way to go.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.