Add-AzSqlElasticJobTarget
Adiciona um destino a um grupo-alvo
Syntax
Add-AzSqlElasticJobTarget
[-Exclude]
[-ResourceGroupName] <String>
[-AgentServerName] <String>
[-AgentName] <String>
[-TargetGroupName] <String>
-ServerName <String>
-DatabaseName <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ResourceGroupName] <String>
[-AgentServerName] <String>
[-AgentName] <String>
[-TargetGroupName] <String>
-ServerName <String>
[-ElasticPoolName <String>]
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ResourceGroupName] <String>
[-AgentServerName] <String>
[-AgentName] <String>
[-TargetGroupName] <String>
-ServerName <String>
-ShardMapName <String>
-DatabaseName <String>
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentObject] <AzureSqlElasticJobTargetGroupModel>
-ServerName <String>
-DatabaseName <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentObject] <AzureSqlElasticJobTargetGroupModel>
-ServerName <String>
[-ElasticPoolName <String>]
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentObject] <AzureSqlElasticJobTargetGroupModel>
-ServerName <String>
-ShardMapName <String>
-DatabaseName <String>
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentResourceId] <String>
-ServerName <String>
-DatabaseName <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentResourceId] <String>
-ServerName <String>
[-ElasticPoolName <String>]
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobTarget
[-Exclude]
[-ParentResourceId] <String>
-ServerName <String>
-ShardMapName <String>
-DatabaseName <String>
[-RefreshCredentialName <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
O cmdlet Add-AzSqlElasticJobTarget adiciona um recurso de destino a um grupo de destino
Exemplos
Exemplo 1: Adicionar um destino de servidor
$tg = Get-AzSqlElasticJobTargetGroup -ResourceGroupName rg -ServerName elasticjobserver -Name tg1
$tg | Add-AzSqlElasticJobTarget -ServerName s1 -RefreshCredentialName cred1
TargetGroupName TargetType TargetServerName TargetDatabaseName TargetElasticPoolName TargetShardMapName RefreshCredentialName MembershipType
--------------- ---------- ---------------- ------------------ --------------------- ------------------ --------------------- --------------
tg1 SqlServer s1 cred1 IncludeExemplo 2: Adicionar um destino de banco de dados
$tg = Get-AzSqlElasticJobTargetGroup -ResourceGroupName rg -ServerName elasticjobserver -Name tg1
$tg | Add-AzSqlElasticJobTarget -ServerName s1 -DatabaseName db2
TargetGroupName TargetType TargetServerName TargetDatabaseName TargetElasticPoolName TargetShardMapName RefreshCredentialName MembershipType
--------------- ---------- ---------------- ------------------ --------------------- ------------------ --------------------- --------------
tg1 SqlDatabase s1 db2 IncludeExemplo 3: Adicionar um destino de pool elástico
$tg | Add-AzSqlElasticJobTarget -ServerName s1 -ElasticPoolName ep1 -RefreshCredentialName cred1
TargetGroupName TargetType TargetServerName TargetDatabaseName TargetElasticPoolName TargetShardMapName RefreshCredentialName MembershipType
--------------- ---------- ---------------- ------------------ --------------------- ------------------ --------------------- --------------
tg1 SqlElasticPool s1 ep1 cred1 IncludeExemplo 4: Adicionar um destino de mapa de fragmentos
$tg = Get-AzSqlElasticJobTargetGroup -ResourceGroupName rg -ServerName elasticjobserver -Name tg1
$tg | Add-AzSqlElasticJobTarget -ServerName s1 -ShardMapName sm1 -DatabaseName db1 -RefreshCredentialName cred1
TargetGroupName TargetType TargetServerName TargetDatabaseName TargetElasticPoolName TargetShardMapName RefreshCredentialName MembershipType
--------------- ---------- ---------------- ------------------ --------------------- ------------------ --------------------- --------------
tg1 SqlShardMap s1 db1 sm1 cred1 IncludeAdiciona um destino (servidor, pool elástico, banco de dados e mapa de estilhaços) a um grupo de destino
Parâmetros
-AgentName
O nome do agente.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AgentServerName
O nome do servidor.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Confirm
Solicita sua confirmação antes de executar o cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DatabaseName
Nome de destino do banco de dados
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-DefaultProfile
As credenciais, a conta, o locatário e a assinatura usados para a comunicação com o Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ElasticPoolName
Nome do destino do pool elástico
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Exclude
Exclui um destino.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ParentObject
O objeto do grupo de destino.
| Type: | AzureSqlElasticJobTargetGroupModel |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ParentResourceId
A ID do recurso do grupo de destino.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-RefreshCredentialName
Atualizar nome da credencial
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
Nome do Grupo de Recursos
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ServerName
Nome de destino do servidor
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ShardMapName
Nome do destino do mapa de fragmentos
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-TargetGroupName
O nome do grupo de destino.
| Type: | String |
| Position: | 3 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WhatIf
Mostra o que aconteceria se o cmdlet fosse executado. O cmdlet não é executado.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Entradas
AzureSqlElasticJobTargetGroupModel
Saídas
Colaborar conosco no GitHub
A fonte deste conteúdo pode ser encontrada no GitHub, onde você também pode criar e revisar problemas e solicitações de pull. Para obter mais informações, confira o nosso guia para colaboradores.
Azure PowerShell
Comentários
Em breve: Ao longo de 2024, eliminaremos os problemas do GitHub como o mecanismo de comentários para conteúdo e o substituiremos por um novo sistema de comentários. Para obter mais informações, consulte https://aka.ms/ContentUserFeedback.
Enviar e exibir comentários de