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!

203 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 Azure there are several alternatives,

    1) SQL Database Elastic Jobs http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-jobs-overview/
    2) The Azure job scheduler http://www.windowsazure.com/en-us/services/scheduler/
    3) The new preview of Azure Automation http://azure.microsoft.com/en-us/services/automation/.
    4) SQL Server in a VM

    I’d love it if folks would take a look at the new Elastic Database jobs, which is in public preview, and give us feedback.
    http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-jobs-overview/
    Thanks Guy, Debra, & team.

    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