Skip to content

Instantly share code, notes, and snippets.

@geralexgr

geralexgr/dedicated-sql-pool-pause-powershell-azure-devops

Created May 6, 2022 08:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geralexgr/6a58c37b5c369d637644b99854e03fec to your computer and use it in GitHub Desktop.
Save geralexgr/6a58c37b5c369d637644b99854e03fec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dedicated-sql-pool-pause-powershell-azure-devops
- task: AzureCLI@2
displayName: az cli stop command
inputs:
azureSubscription: 'YOURSUB'
scriptType: 'pscore'
scriptLocation: 'inlineScript'
inlineScript: |
$token = az account get-access-token | ConvertFrom-Json
$mytoken = $token.accesstoken
$headers = @{
Authorization = "Bearer $mytoken"
}
Invoke-RestMethod -Method Post -Uri "https://management.azure.com/subscriptions/xxxxx-xxxxx-xxxxx/resourceGroups/resource-group/providers/Microsoft.Sql/servers/sql-server/databases/database/pause?api-version=2020-11-01-preview" -Headers $headers -UseBasicParsing -ContentType 'application/json'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment