Jaspersoft ETL

Hi, I've been with an error that I can not solve, I hope you can help me.

I am trying to execute the following routine in one ("tMySqlRow")

"SET @ID = (select min (ID) from execution
                       where PERIOD = concat (year (now ()), LPAD (month (now ()), 2, 0))
                           and IDINDICATOR = 1);
delete from execution
where id = @ID "

but I always get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from ejecucion
where id = @ID' at line 4

any ideas? I do not know how to solve it.