MySQL Forums
Forum List  »  Events (Job Scheduler)

How to call a Stored Procedure from a Scheduled Event in MySql using PhpMyAdmin?
Posted by: Surodip Patra
Date: February 06, 2014 12:38AM

I am using PhpMyAdmin console for my MySQL DB. I have a Routine in DB and I want to call the routine on the last date of every month. I set up an event and for testing purpose I have set it for 1 min interval:

CREATE EVENT `monthly_report` ON SCHEDULE EVERY 1 MINUTE STARTS '2014-02-05 07:50:00' ON COMPLETION PRESERVE ENABLE DO CALL Test_Proc()
But it is never been called. Can anyone help me?

Regards,
Surodip

Options: ReplyQuote


Subject
Views
Written By
Posted
How to call a Stored Procedure from a Scheduled Event in MySql using PhpMyAdmin?
6584
February 06, 2014 12:38AM


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.