< Back

Stop-AzureRmSqlElasticPoolActivity

Tue Jan 29, 2019 10:10 pm

NAME Stop-AzureRmSqlElasticPoolActivity



SYNOPSIS

Cancels the asynchronous update operation on an elastic pool.





SYNTAX

Stop-AzureRmSqlElasticPoolActivity [-ResourceGroupName] <String> [-ServerName] <String> [-ElasticPoolName] <String> [-DefaultProfile

<IAzureContextContainer>] [-OperationId <Guid>] [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Stop-AzureRmSqlElasticPoolActivity cmdlet cancels the asynchronous update operation on an elastic pool.





PARAMETERS

-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with Azure.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ElasticPoolName <String>

The name of the Azure SQL Elastic Pool.



Required? true

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-OperationId <Guid>

The ID of the operation to retrieve.



Required? false

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

The name of the resource group.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

The name of the Azure SQL Server the Elastic Pool is in.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

You can pipe input to this cmdlet by property name, but not by value.





OUTPUTS

System.Object







NOTES









Example 1: Cancel the asynchronous update operation on an elastic pool



PS C:\\> Stop-AzureRmSqlElasticPoolActivity -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01"

-OperationId af97005d-9243-4f8a-844e-402d1cc855f5



OperationId : af97005d-9243-4f8a-844e-402d1cc855f5

ServerName : Server01

DatabaseName : ElasticPool01

State : CANCELLED

Operation : UpdateLogicalElasticPool

ErrorCode :

ErrorMessage :

ErrorSeverity :

StartTime : 10/15/2017 02:49:42 PM

EndTime : 10/15/2017 02:49:43 PM

PercentComplete :



This command cancels the asynchronous updates operation on the elastic pool.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... olactivity