Scripting Auto Pause & Resume for two azure services

Question

Hello All:

I am looking for script that can auto pause & resume Azure Synapse Dedicated SQL Pool & Azure ML Compute Node.

I need a pointer and or a link which will help me to get a head start.

Any help or link is greatly appreciated.

Thanks

Answer 1

Hello:

I was able to find python commands in Microsoft Documentations, I need help for scripting on Azure Synapse.

How to stop Azure ML Compute Instance using Python. (I hope it will help others)
https://github.com/dem108/azureml-compute-instance-mgmt

-- get_status() gets the latest status of the ComputeInstance target
instance.get_status()

-- stop() is used to stop the ComputeInstance
-- Stopping ComputeInstance will stop the billing meter and persist the state on the disk.
-- Available Quota will not be changed with this operation.
instance.stop(wait_for_completion=True, show_output=True)

-- start() is used to start the ComputeInstance if it is in stopped state
instance.start(wait_for_completion=True, show_output=True)

-- restart() is used to restart the ComputeInstance
instance.restart(wait_for_completion=True, show_output=True)

Thanks

Answer 2

Hello @Jayesh Dave ,
Thanks for the ask and using the Microsoft Q&A platform .
Just wanted to point you to the below document , Its should help .

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/how-to-pause-resume-pipelines#:~:text=Pause%20and%20resume%20for%20dedicated,an%20existing%20data%20orchestration%20process.

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members