3

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.

Community
  • 1
  • 1
Kyle
  • 17,317
  • 32
  • 140
  • 246

3 Answers3

3

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/

Scott Scowden
  • 1,155
  • 2
  • 11
  • 19
  • 1
    It seems this is tightly coupled to Mobile Services. Why? Are there limitations there? Seems interesting but also seems retarded to tie this directly to Mobile Services in any way... – Jaxidian Feb 14 '13 at 23:12
  • I agree with @Jaxidian that it seems odd its tied into Mobile Services. Also it looks like you can only get access to mobile services if you have the preview option enabled (I currently do not). That said, this does look like the best solution at the moment. – Kyle Feb 15 '13 at 13:04
2

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.

Cotega
  • 339
  • 1
  • 2
  • 8
1

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

gaynorvader
  • 2,619
  • 3
  • 18
  • 32
Steve Macculan
  • 2,292
  • 5
  • 22
  • 32