[RESOLVED] How do I schedule a query in Azure Db?
I have an Azure SQL Server Db, not one running on a VM, and I would like to schedule a simple SQL Query to run periodically to delete rows from a table based on age. I can make the query, but how does one schedule queries to run in and Azure SQL Server Db?
Re: How do I schedule a query in Azure Db?
As far as I'm aware, you don't do it IN the database. For a regular SQL Server instance you would use SQL Server Agent but there is no such thing in Azure. For scheduled tasks in Azure, you can create a WebJob if you already have an App Service and you can create an Azure Function otherwise. The latter is a beefed up version of the former, or maybe it's more correct to say that the former is a stripped down version of the latter.
Re: How do I schedule a query in Azure Db?
Thanks a million John. You saved me time looking for something i don't have. I don't want to learn about WebJob and the App service yet so I think I'll just make an app on my desktop computer and schedule it. YOu rock. Thanks again.