how to run an event in Mysql under azure

Question

how to run an event in Mysql under azure

Anthony Buitrago 25

Hello I create an event in mySql server on Azure however the event is not raised, but if I made a replica database on my local machine the event is raised every day as expected On azure if i try to create again the event , I have an error , because the event is already created,

thank you in advance

CREATE EVENT TaskByDayEvent
  ON SCHEDULE     EVERY 1 DAY     STARTS '2023-04-15 09:39:00' ON COMPLETION PRESERVE ENABLE 
  DO     call bcproj.insertIntorestaskbyday();

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-14T23:34:36.5266667+00:00

@Anthony Buitrago Welcome to the Microsoft Q&A forum, Thanks for posting your question.

If I understand correctly the event is not running as expected on your Azure MySQL, but it is running correctly on your replica database.

If the event already exists in the Azure Mysql try to drop the event DROP EVENT IF EXISTS event_name; and create again. Can you share the steps you followed? or an error screenshot?

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-17T22:07:11.59+00:00

@Anthony Buitrago We haven't heard back from you. Just wanted to check if you had the chance to check my response
Anthony Buitrago 25 Reputation points

2023-04-18T16:29:23.9433333+00:00
Sorry and thank you for your response, I was sick :), Concerning my issue I already drop the event in Azure and still have the same problem the event don't run, also I don't see any error here My steps

DROP EVENT TaskByDayEvent;

CREATE EVENT TaskByDayEvent ON SCHEDULE EVERY 1 DAY STARTS '2023-04-18 09:39:00' ON COMPLETION PRESERVE ENABLE DO call bcproj.insertIntorestaskbyday(); that's it. if I call My Store proc manually the sp works correctly
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Accepted answer

0 additional answers

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-14T23:34:36.5266667+00:00

@Anthony Buitrago Welcome to the Microsoft Q&A forum, Thanks for posting your question.

If I understand correctly the event is not running as expected on your Azure MySQL, but it is running correctly on your replica database.

If the event already exists in the Azure Mysql try to drop the event DROP EVENT IF EXISTS event_name; and create again. Can you share the steps you followed? or an error screenshot?

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-17T22:07:11.59+00:00

@Anthony Buitrago We haven't heard back from you. Just wanted to check if you had the chance to check my response
Anthony Buitrago 25 Reputation points

2023-04-18T16:29:23.9433333+00:00

Sorry and thank you for your response, I was sick :), Concerning my issue I already drop the event in Azure and still have the same problem the event don't run, also I don't see any error here My steps

DROP EVENT TaskByDayEvent;

CREATE EVENT TaskByDayEvent ON SCHEDULE EVERY 1 DAY STARTS '2023-04-18 09:39:00' ON COMPLETION PRESERVE ENABLE DO call bcproj.insertIntorestaskbyday(); that's it. if I call My Store proc manually the sp works correctly
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

@Anthony Buitrago I tried to repro and able to get event_scheduler working in both Single and Flexible Server. Set the server parameter event_scheduler to ON and follow steps from below documents, it should work.

MySQL :: MySQL 5.7 Reference Manual :: 23.4 Using the Event Scheduler
MySQL :: MySQL 8.0 Reference Manual :: 25.4 Using the Event Scheduler To clarify, do you mean by a replica that you have a MySQL on-prem replicating from Azure Database for MySQL or other way around? If you are hitting a duplicate event error, you can always give a different name for the event and test it out Regards Geetha

Anthony Buitrago 25 Reputation points

2023-04-25T15:21:49.1633333+00:00

thank you a lot for your help

Share via

how to run an event in Mysql under azure

0 additional answers

Your answer