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!
Scott Dowling
shared this idea
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.
11 comments
-
Anonymous
commented
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. -
Anonymous
commented
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.
-
Henry
commented
Another option is to use Cotega (www.cotega.com) which can be used to schedule execution of stored procs in SQL Azure
-
Jason
commented
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
-
Henry
commented
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
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?
-
Alex
commented
Would like to see scheduler based capabilities to run application centric jobs