how can i fire a store procedure in mysql repeatedly after some fixed days?

[projjwal]

Hi Everyone,

I need to fire a procedure which will upade a table after a certain interval.can anyone tell me..how to fire a store procedure after some some fixed days?

[Atli]

MySQL itself does not have a feature like this.
It only executes code when it receives a command to do so.

This would be more of an OS thing.
Which OS are you using? Linux?

On Linux, you can create a cron-job. A scheduled execution of a command or a script.
Windows can also do this.

All you need to do is create a script that executes your procedure, and have your OS execute that script.