Event created not executed and status became "DISABLED"
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
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.