Clever Geek Handbook

SQL Server Azure - Execute a stored procedure every x minutes

Typically, with SQL Server, I could set up a job and run it as often. Something like . However, SQL Server Azure doesn't seem to have this ability.

My thoughts were to have a service that does this routine every x minutes. I'm just wondering if anyone has any problems with this, or have any better suggestions?

The stored procedure takes some XML data stored in one table and normalizes it to other tables, making it easier to query.

+3


source to share


3 answers


You can schedule tasks using the new Scheduler:

http://weblogs.asp.net/scottgu/archive/2012/12/21/great-updates-to-windows-azure-mobile-services-web-sites-sql-data-sync-acs-media-more. aspx



More details: http://www.windowsazure.com/en-us/develop/mobile/tutorials/schedule-backend-tasks/

+3


source


If you are open to using the service, Cotega offers the ability to schedule the execution of stored procedures from SQL Azure. You can read more about how to schedule these assignments here .



Full disclosure, I am working on this service.

+2


source


You can run a scheduled task execution task directly from your application using Quartz for example.

+1


source






More articles:


All Articles