This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 62%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
I just migrated a MySQL database schema from a local server to Azure. In this schema, I have two SQL events verifying some data at a certain point of the day. both the events worked fine in the on-premises server, but not in the azure mysql database instance. Is there any additional configuration required for SQL event handling in Azure MySQL database? Thanks in advance. I was using MySQL server 8.0.35 in the on-premises server. I've already tried deleting and creating the events again in Azure.
Hi @Alejandro Sanchez Sanchez Thanks for posting your question in the Microsoft Q&A forum.
Our Azure MySQL is currently on 8.0.34 version, can you please share the exact error you are seeing?
Regards
Geetha
It's not displaying an error. I created an event in MySQL that checks, every 24 hours, if there's a new entry to a specific table on the database. If not, then updates a column on another table. It worked just fine in an on-premises server, which contained the database initially, but even if the event is actually showing with status enabled on the Azure Database for MySQL, it does not do what it's supposed to do. Here's a screenshot of the event in MySQL workbench:
Hi @Alejandro Sanchez Sanchez This needs more troubleshooting I would suggest raising a support case For deeper investigation and immediate assistance, If you have a support plan you may file a support ticket, else could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details, to work closely on this issue.
Email subject: <Attn - Geetha : Microsoft Q&A Thread title>
Thread URL: <Microsoft Q&A Thread>
Subscription ID: <your subscription id>
Looking forward to your reply.
Regards,
Geetha
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)