Open SQLPS console and connect to target Availability Replica.
Target | Microsoft.SQLServer.Windows.AvailabilityReplica |
Application | powershell.exe |
WorkingDirectory | |
isRequireOutput | False |
Accessibility | Internal |
Enabled | True |
<ConsoleTask ID="Microsoft.SQLServer.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell" Accessibility="Internal" Target="SqlDiscW!Microsoft.SQLServer.Windows.AvailabilityReplica" RequireOutput="false">
<Assembly>Res.Microsoft.SQLServer.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell</Assembly>
<Handler>ShellHandler</Handler>
<Parameters>
<Argument Name="Application">powershell.exe</Argument>
<Argument Name="WorkingDirectory"/>
<Argument>-NoExit -NoLogo -NoProfile -Command Invoke-Command {
$IncludeFileContent/Scripts/PsTaskCommon.ps1$
$p = 0
$destInstanceNameParam = @'
$Target/Property[Type="System!System.Entity"]/DisplayName$
'@
$p = 0
$agNameParam = @'
$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityReplica"]/AvailabilityGroupName$
'@
$p = 0
$arNameParam = @'
$Target/Property[Type="System!System.Entity"]/DisplayName$
'@
$destInstanceName = GetInstancePathName $destInstanceNameParam
$agPathName = EncodeSqlName $agNameParam
$arPathName = EncodeSqlName $arNameParam
cd ('sqlserver:\SQL\{0}\AvailabilityGroups\{1}\AvailabilityReplicas\{2}\' -f $destInstanceName, $agPathName, $arPathName)
}</Argument>
</Parameters>
</ConsoleTask>