MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: scheduled batch command
Posted by: Anthony Thomas
Date: July 10, 2012 11:24AM

Apparently the solution is to put everything into the sql file. So in my case the content of test.sql should look like this:

delimiter |
create event e_test on schedule every 1 day do
{sql statement 1};
{sql statement N};
end |
delimiter ;

Then execute
mysql> source /var/www/home/test.sql;

Options: ReplyQuote

Written By
July 10, 2012 06:44AM
Re: scheduled batch command
July 10, 2012 11:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.