scheduled database event

[BubikolRamios]

this code is eaten by database, no errors, I can even
delete event galery_1
the sql is allso ok, and does what I want, checked it.

so all ok, but nothing happens ?


delimiter |
CREATE EVENT galery_1
ON SCHEDULE
EVERY 10 SECOND
DO
BEGIN
update galery_1
set home_jsp= CURRENT_TIMESTAMP()
where home_jsp is null
order by DSP asc limit 1;
END |
delimiter


edit:


SET GLOBAL event_scheduler = 1;

[Inigoesdr]

this code is eaten by database, no errors, I can even
delete event galery_1
the sql is allso ok, and does what I want, checked it.
Try DROP EVENT galery_1