As far as I know, MySQL doesn't have built-in cron jobs. If you are on a *nix type system, look into the "crontab" program to schedule tasks.
For web hosting, you have to check with them to see if they support that. Most hosting control panels have a section just for cron jobs and it's pretty easy to configure them (once you know what command you want to run).
hi, I am on windows NT and i run mysql 5.1.33. I really dont know how to see if there is that cron job option. By the way, assuming the cron job on my windows machine is possible, can that cron job be executed when i am off my work and the computer turned off? regards.
There's a number of online cron replacement services out there. If you're on free web hosting and don't have access to cron, or are on a local machine but don't want to leave it on all the time, this is a GREAT option.
[edited by: tedster at 9:56 pm (utc) on Dec. 15, 2009]