how to view the history of an event
I am running Mysql Server version: 5.1.36-community-log
Protocol version: 10 on Windows WAMP server. I have an event that supposed to run an Stored procedure everyday and 2am. I know the SP works but I don't see the event being triggered.
--> How can I review the log and see any sort of error with the event?
Event in question:
DROP EVENT `cleanRev_cdmrpUpdates`//
CREATE EVENT `cleanRev_cdmrpUpdates` ON SCHEDULE EVERY 1 DAY STARTS '2011-07-14 02:00:00' ON COMPLETION PRESERVE ENABLE COMMENT 'Daily backup and purge of rev_cdmrp.updates table' DO call sp_cleanRev_cdmrpUpdates()
Subject
Written By
Posted
how to view the history of an event
July 20, 2011 10:42AM
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.