SQL Database Event

David Částka 26

Hi, how can i create event ? I need to update the data in each row at 12:00 every day.

Thanks for help

Alberto Morillo 32,886 Reputation points MVP

2022-05-15T16:41:09.027+00:00

Please describe better your requirements.
David Částka 26 Reputation points

2022-05-15T20:44:52.727+00:00

In MySQL is scheduled event, but in azure database i cant find
GeethaThatipatri-MSFT 27,417 Reputation points Microsoft Employee

2022-05-15T21:09:50.833+00:00

Hi, @David Částka are you looking at how to enable auditing in Azure SQL shown as below? so we can provide you with more details.

Regards
Geetha

Accepted answer

Alberto Morillo 32,886 Reputation points MVP

2022-05-15T23:16:38.203+00:00

On Azure SQL Database you schedule tasks by using Azure Automation. On this article you will find how to schedule, for example, the execution of a stored procedure on an Azure SQL Database by creating a runbook on Azure Automation.

Azure SQL database does not have a scheduler integrated to it. Azure Automation makes the function of scheduler for other Azure products.
Please sign in to rate this answer.
GeethaThatipatri-MSFT 27,417 Reputation points Microsoft Employee

2022-05-17T16:44:00.337+00:00

@David Částka Please let us know if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Thanks, @Alberto Morillo for your continued support and contribution.

Regards
Geetha

Alberto Morillo 32,886 Reputation points MVP

2022-05-17T17:00:34.73+00:00

Thank you @GeethaThatipatri-MSFT for your continuos support
Sign in to comment

0 additional answers