Kyle Kyle - 2 years ago 94
C# Question

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download