MySQL Forums
Forum List  »  Events (Job Scheduler)

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
Views
Written By
Posted
Event created not executed and status became "DISABLED"
167
August 03, 2020 07:36AM


Sorry, only registered users may post in this forum.

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.