Post reply

How to Run Scheduled Jobs in Azure SQL Databases

  • July 31, 2016 at 10:03 am

    #328754

    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

    #1892875

    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

    #1892878

    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

    #1892887

    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

    #1892906

    I agree, however, you can use the task scheduler of your Windows OS to automate the tasks.

  • August 1, 2016 at 7:06 am

    #1892937

    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

    #1893024

    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

    #1893037

    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

    #1893043

    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

    #1893059

    You are absolutely right.

  • August 1, 2016 at 5:49 pm

    #1893095

    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

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 1, 2016 at 6:17 pm

    #1893097

    hahahaha. I agree.

  • August 7, 2016 at 9:24 am

    #1894220

    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

    #1894228

    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

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply