July 31, 2016 at 10:03 am
Comments posted to this topic are about the item How to Run Scheduled Jobs in Azure SQL Databases
August 1, 2016 at 2:21 am
Thanks for this fine piece Daniel!
😎
My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to run the scheduled jobs from, unfortunately this approach will not help in that situation. Maybe someone will start offering such a service....;-)
August 1, 2016 at 2:42 am
Eirikur Eiriksson (8/1/2016)
Thanks for this fine piece Daniel!😎
My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to run the scheduled jobs from, unfortunately this approach will not help in that situation. Maybe someone will start offering such a service....;-)
Azure Automation?
August 1, 2016 at 3:45 am
BLOB_EATER (8/1/2016)
Eirikur Eiriksson (8/1/2016)
Thanks for this fine piece Daniel!😎
My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to run the scheduled jobs from, unfortunately this approach will not help in that situation. Maybe someone will start offering such a service....;-)
Azure Automation?
More thinking of SQL Server Agent compatible service.
😎
August 1, 2016 at 5:57 am
I agree, however, you can use the task scheduler of your Windows OS to automate the tasks.
August 1, 2016 at 7:06 am
I agree with the prior comments. This article requires a local (on-premise) SQL Server and Management Studio. There needs to be a way to schedule jobs in SQL Azure without needing Management Studio installed somewhere else.
At the moment, Windows Scheduled Tasks running a SQLCMD command is the only way I can think of to simulate what we do in SQL Server Agent now.
The Azure development team really need to get onto this area.
August 1, 2016 at 12:02 pm
Great article and definitely applicable for SSIS jobs, the VM could be host for the packages running against said Azure SQL DB/DW, however Azure Automation, Elastic Database Jobs, and Azure Data Factory Stored Procedure Executions are more lighter weight approaches for executing "jobs" on the PaaS layer, Azure SQL DB/DW.
August 1, 2016 at 1:04 pm
Elastic databases and Data Factory are the best options if you want to pay extra in Azure. However if you already have a local SQL Server installed, this option in the article is OK. If you do not have a local SQL Server, Using the Windows Task Scheduler would be a good option.
August 1, 2016 at 1:14 pm
Agreed there is more cost, but you are also gaining a lot more, along with a fully supported and scale-able infrastructure that you don't have to physically support hardware or OS for. The capabilities in a public cloud world are quite robust when you look at things as: "here are my options to achieve X.Y. and Z... when you add webjobs into the mix as data extraction jobs/processes (ELT/ETL), Web Apps, Task Scheduler on a VM, and Azure Automation become ways you can execute the WebJob code, sometimes VMs are your only option depending on what you're trying to achieve.
August 1, 2016 at 1:59 pm
You are absolutely right.
August 1, 2016 at 5:49 pm
As a bit of a sidebar, I think that any system that allows for the use of a password "in the clear" is a really bad idea no matter the claimed gain in automation.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2016 at 6:17 pm
hahahaha. I agree.
August 7, 2016 at 9:24 am
Looks like using azure automation and a runbook is the prefer way for WindowAzure. You will need to know powershell to execute the SQL command. like invoke-sqlcmd.
https://drive.google.com/open?id=0B0S1Vqb-7RcfelBBejdFMWxFYzQ
https://drive.google.com/open?id=0B0S1Vqb-7RcfWGhZUXRsekpUSjA
Pedro Lopez
FIS
August 7, 2016 at 10:31 am
pedrolopezmail (8/7/2016)
Looks like using azure automation and a runbook is the prefer way for WindowAzure. You will need to know powershell to execute the SQL command. like invoke-sqlcmd.https://drive.google.com/open?id=0B0S1Vqb-7RcfelBBejdFMWxFYzQ
https://drive.google.com/open?id=0B0S1Vqb-7RcfWGhZUXRsekpUSjA
Heh... I easily avoid both such limiting problems. 🙂 I don't use the cloud. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply