How to Run Scheduled Jobs in Azure SQL Databases

  • Comments posted to this topic are about the item How to Run Scheduled Jobs in Azure SQL Databases

  • 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....;-)

  • 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?

  • 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.

    😎

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

  • 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.

  • 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.

  • 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.

  • 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.

  • You are absolutely right.

  • 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)

  • hahahaha. I agree.

  • 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

  • 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