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.
You can schedule jobs using the new Scheduler: