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.
9 comments
-
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