SQL repeat events by timer

Question

I want that a column of my database, composed by float random numbers, change every x seconds determined by a timer.
I read about Schedule Tasks Events but i can't work it.
Please help

Answer 1

I'm only familiar with sql server, but could you set up a stored proc with an infinite loop and a wait?

Answer 2

The following statement solve part of the problem, i hope it will be useful for others users:

CREATE EVENT addTimer 
ON SCHEDULE EVERY 2 SECOND 
STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 9 HOUR 
DO 
UPDATE prova.prova SET actual = actual + 1