MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: Problems with Scheduling event to Call Stored Procedure
Posted by: Antonio Reale
Date: September 17, 2009 07:27AM

Roel Van de Paar Wrote:
-------------------------------------------------------
> Please provide output of:
>
> mysql> SHOW EVENTS;

I have the same problem with mysql-5.1.32 ndb-7.0.5.
Here's my "SHOW EVENTS;":
"kamailio" "create_cdr" "root@%" "SYSTEM" "RECURRING" (NULL) "1" "MINUTE" 2009-09-17 13:16:45 (NULL) "ENABLED" 0 "utf8" "utf8_general_ci" "latin1_swedish_ci"

Event scheduler global variable is ON.

The field "last execute" in the EVENTS table reports that the event is executed but I can't see the results. If I execute manually "call SP()" the stored procedure works.

I tried to debug with "mysqladmin debug" but it doesn't show any output.

Could you please provide some tips to debug this problem?
Thanks. Regards,

Antonio

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problems with Scheduling event to Call Stored Procedure
5456
September 17, 2009 07:27AM


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.