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 two possible alternatives, SQL Server in a VM, or the Windows Azure job scheduler http://www.windowsazure.com/en-us/services/scheduler/. Please send me email if you have scenarios that don’t work with either of these two options. Guyhay@microsoft.com
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