I have an Azure DB. As we all know, that means no SQL Agent. I need to have a background task that runs every few minutes to clean up some things. Since I can't setup an Agent job, I was thinking about a sproc with an infinite loop. That does some work every 5 min. (or whatever). The alternative is an Azure web role. That's probably a better solution, but it's also much more expensive.
Any thoughts on the infinite loop thing? Is there any way to "sleep" in a sproc?