CODEWITHSUNDEEP
c#sql-server-2008azureazure-sql-database
Kyle
Kyle

Reputation: 17687

SQL Server Azure - Executing stored procedure every x minutes

Generally with SQL Server, I could setup a job and have it run every so often. Something like this. However SQL Server Azure does not seem to have this ability.

My thoughts were to instead, have a service that runs this procedure every x minutes. I'm just wondering if anyone sees any issues with that, or has any better suggestions?

The stored procedure takes some xml data stored in one table and normalizes it across other tables making it easier to query on.

Upvotes: 3

Views: 3597

Answers (3)

Steve Macculan
Steve Macculan

Reputation: 2322

You can trigger scheduled task running procedure directly from your application using, for example, Quartz.

Upvotes: 1

Cotega
Cotega

Reputation: 339

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

Full disclosure, I work on this service.

Upvotes: 2

Scott Scowden
Scott Scowden

Reputation: 1195

You can schedule jobs 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 Detail: http://www.windowsazure.com/en-us/develop/mobile/tutorials/schedule-backend-tasks/

Upvotes: 3

Related Questions