MySQL Forums
Forum List  »  General

Event created not executed and status became "DISABLED"
Posted by: NPO CNHi Support
Date: August 03, 2020 07:36AM

Good morning,
i am facing this issue:
i am trying to create an event that trigger a stored procedure but after the time set arrive the event change from ENABLED to DISABLED and the store procedure is not triggered.
The event scheduler is ON obviously:


mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| ON |
+--------------------------+
1 row in set (0.00 sec)

DROP EVENT IF EXISTS run_qlik_refresh;
SET GLOBAL event_scheduler = ON;
CREATE EVENT run_qlik_refresh ON SCHEDULE AT '2020-08-03 15:15:00' DO CALL qlik_refresh();
COMMIT;

Does anybody every faced this problem or has a clue on how to solve it?
Thank you.

RHEL 7.6
Server version: 8.0.16-Community

Options: ReplyQuote


Subject
Written By
Posted
Event created not executed and status became "DISABLED"
August 03, 2020 07:36AM


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.