MySQL to trigger update statement on a specific day & time

[Bernard Bailey]

Hi team,

I have a requirement in MySQL to trigger an update statement on a calendar table on a specific day & time.

I understand triggers can only work on the basis of a BEFORE or AFTER state during an update of a field in a table.

I can not find anywhere for a method to cause a table update, unless I use a cron job.

Are there any MySQL tools that can run a sql statement on the specific day of the week and time?

Or is there a work around which will achieve the same result?

All assistance is appreciated.

Cheers
Bernard Bailey