How can we improve Azure SQL Database?

Add SQL Server Agent or its ability to create custom jobs

Ability to create jobs that can run from 1 minute, 1 hour etc.

BTW Love SQL Azure keep up the good work guys!

206 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Scott DowlingScott Dowling shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Today in Windows Azure there are several alternatives, SQL Server in a VM, the Windows Azure job scheduler http://www.windowsazure.com/en-us/services/scheduler/ and the new preview of Azure Automation http://azure.microsoft.com/en-us/services/automation/. Our recommended way is Azure Automation and recently Joseph blogged on how to do typical SQL Database tasks, much like you can do on-premise with SQL Agent.

    Please see Joseph’s blog article for more details. http://azure.microsoft.com/blog/2014/06/26/azure-automation-your-sql-agent-in-the-cloud/

    8 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • JasonJason commented  ·   ·  Flag as inappropriate

        The new Azure scheduler features solved our custom job needs. Thanks.

      • Mark RichardsMark Richards commented  ·   ·  Flag as inappropriate

        Seems to me that Azure recently released a new schedule service, where you can schedule tasks to run on intervals. Maybe you can use that to schedule tasks to kick off what you need. unfortunately, I can't actually find it in the management portal, and I'm too lazy to find the article. ;)

      • Bill ChengBill Cheng commented  ·   ·  Flag as inappropriate

        An SQL Server agent-like function local to Windows Azure SQL Database would be great to run SQL Server-internal things, which are traditionally useful to DBA, like index defrag, database integrity check, writing a worker role to do that is too cumbersome

      • HenryHenry commented  ·   ·  Flag as inappropriate

        Have you tried cotega.com? You can do things like scheduled database backups and run custom stored procs on a scheduled basis. it is still in beta though.

      • LarryLarry commented  ·   ·  Flag as inappropriate

        It would be great to run SQL script or execute a web service/WCF/HTTP post. Some form of SSIS would be useful.

      • AlexAlex commented  ·   ·  Flag as inappropriate

        Would like to see scheduler based capabilities to run application centric jobs

      Feedback and Knowledge Base