locked
DB Maint Task RRS feed

  • Question

  • I need to setup some sort of a background task to do some DB cleanup sorts of things on my SQL Azure DB. Normally, I'd throw a couple lines of TSQL in a SQL Agent Job and be done with it. Obviously, SQL Agent is not available on a SQL Azure DB. Anybody have any other ideas? It seems to me that a separate "worker role" would sure be an expensive solution. Someone else suggested setting up another "on premise" SQL Server Agent to do the job.
    Monday, January 10, 2011 12:18 AM

Answers

  • Hi,

    Currently, SQL Azure doesn’t support running SQL Server Agent in the cloud. If you need SQL Server Agent type functionality for SQL Azure, you can use a Windows Azure worker role and some custom code. More information, you can refer to below blog series:

    http://blogs.msdn.com/b/sqlazure/archive/2010/07/30/10044271.aspx

     

    Hope this helps,

    Raymond


    Raymond Li - MSFT
    • Marked as answer by BSavoie Friday, January 14, 2011 4:08 AM
    Tuesday, January 11, 2011 8:39 AM