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!
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.
Thanks Guy, Debra, & team.
It is obvious that you made a relatively simple "right-click on a GUI" operation into coding nightmare, for the sole purpose of selling re-packaged single-purpose solutions such as the data factory.
I really do hope that at some point, you all get outsourced.
Larry Smith commented
Years later, SQL Database Elastic Jobs is STILL in preview.
Microsoft, have you abandoned this crucial service? It's just as raw as day 1, and when it gets hung up, it's a disaster for clients.
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.
Another option is to use Cotega (www.cotega.com) which can be used to schedule execution of stored procs in SQL Azure
The new Azure scheduler features solved our custom job needs. Thanks.
Mark Richards commented
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
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
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.
It would be great to run SQL script or execute a web service/WCF/HTTP post. Some form of SSIS would be useful.
Ajay Kalhan commented
what kind of jobs do you want to run?
Would like to see scheduler based capabilities to run application centric jobs