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 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/
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