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
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Scott 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.

9 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Neither Azure Automation or Azure Scheduler have the easy simple operation of SQL Agent. Yes, they are "alternatives", but very poor in comparison to the real thing.

  • Jason commented  ·   ·  Flag as inappropriate

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

  • Mark 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 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

  • Henry 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.

  • Larry 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.

  • Alex commented  ·   ·  Flag as inappropriate

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

Feedback and Knowledge Base