Automatic stop and start of SQL Server Data Warehouse RRS feed

  • Question

  • What is best practice and tool for stopping Dev environment for nights and weekends? Any tips?


    Thursday, April 4, 2019 1:19 PM

All replies

  • Hi Kenny,

    You can easily do this using an Automation Account which is scheduled to run at a specific time, you also have the runbook gallery in the Automation Account with prebuilt solutions you can use.

    Thursday, April 4, 2019 1:31 PM
  • Hi Kenny,

    Thanks for your feedback. You can do this using Automation Account as mentioned earlier. Also you can automate the compute management using azure functions as per your requirement.

    You can refer below URLs for the same:

    Automation Account for DWH

    Automation Account

    Automating compute management

    Hope it helps.

    • Proposed as answer by angoyal-msft Friday, April 5, 2019 8:40 AM
    Friday, April 5, 2019 8:40 AM