var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Batch Jobs in MySQL
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.