Dear Friends,

What is the equivalent of oracle jobs in MySQL?

I have a requirement in which the data in selected tables will be archived and moved to other tables. For this purpose I had created a stored procedure that will do the work for me.

Now the question is - how to schedule to run this stored procedure every week (say on friday night at 8 PM) automatically.

Thanks in advance.

I believe you need to write a cron job to call that stored procedure in batch mode. I'm pretty sure MySQL does not the capability to schedule jobs.