Add-AzSqlElasticJobTarget

參考

模組:: Az.Sql

將目標新增至目標群組

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

Add-AzSqlElasticJobTarget Cmdlet 會將目標資源新增至目標群組

範例

範例 1：新增伺服器目標

$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                 Include

範例 2：新增資料庫目標

$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                                                                               Include

範例 3：新增彈性集區目標

$tg | Add-AzSqlElasticJobTarget -ServerName s1 -ElasticPoolName ep1 -RefreshCredentialName cred1

TargetGroupName TargetType     TargetServerName TargetDatabaseName TargetElasticPoolName TargetShardMapName RefreshCredentialName MembershipType
--------------- ----------     ---------------- ------------------ --------------------- ------------------ --------------------- --------------
tg1             SqlElasticPool s1                                  ep1                                      cred1                 Include

範例 4：新增分區對應目標

$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                 Include

將目標（伺服器、彈性集區、資料庫和分區對應）新增至目標群組

參數

-AgentName

代理程式名稱。

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-AgentServerName

伺服器名稱。

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

執行 Cmdlet 之前先提示您確認。

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DatabaseName

資料庫目標名稱

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-DefaultProfile

用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶。

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ElasticPoolName

彈性集區目標名稱

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

-Exclude

排除目標。

Type:	SwitchParameter
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ParentObject

目標組物件。

Type:	AzureSqlElasticJobTargetGroupModel
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ParentResourceId

目標群組資源標識碼。

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-RefreshCredentialName

重新整理認證名稱

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

資源群組名稱

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ServerName

伺服器目標名稱

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ShardMapName

分區對應目標名稱

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-TargetGroupName

目標組名。

Type:	String
Position:	3
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

顯示執行 Cmdlet 後會發生的情況。未執行 Cmdlet。

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

輸入

AzureSqlElasticJobTargetGroupModel

輸出

JobTarget