question

Davidstka-2761 avatar image
1 Vote"
Davidstka-2761 asked AlbertoMorillo commented

SQL Database Event

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

Thanks for help

azure-sql-database
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please describe better your requirements.

0 Votes 0 ·

In MySQL is scheduled event, but in azure database i cant find

0 Votes 0 ·

Hi, @Davidstka-2761 are you looking at how to enable auditing in Azure SQL shown as below? so we can provide you with more details.
202086-image.png

Regards
Geetha


0 Votes 0 ·
image.png (70.6 KiB)

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Davidstka-2761 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, @AlbertoMorillo for your continued support and contribution.

Regards
Geetha

0 Votes 0 ·
AlbertoMorillo avatar image AlbertoMorillo GeethaThatipatri-MSFT ·

Thank you @GeethaThatipatri-MSFT for your continuos support

0 Votes 0 ·