Jump to content


Timed code executions in MySQL?

  • Please log in to reply
3 replies to this topic

#1 kerunt

  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 26 February 2006 - 05:45 AM


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?


#2 wickning1

  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 26 February 2006 - 06:36 AM

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.

#3 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 February 2006 - 06:43 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 kerunt

  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 26 February 2006 - 08:34 PM

Thanks guys.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users