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!
Adding SQL Server Agent or similar scheduling tool to SQL Database will allow scheduled processes. This would make SQL Database more useful.
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.
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