Set-​Azure​Sql​Job​Target

Updates a job target definition.

Syntax

Set-AzureSqlJobTarget
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -ShardMapManagerCredentialName <String>
   -ShardMapManagerDatabaseName <String>
   -ShardMapManagerServerName <String>
   -ShardMapName <String>
   [-LiteralServerName]
   [<CommonParameters>]
Set-AzureSqlJobTarget
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-LiteralServerName]
   -MasterDatabaseCredentialName <String>
   -ServerName <String>
   [<CommonParameters>]

Description

The Set-AzureSqlJobTarget cmdlet updates a job target definition. This currently enables a specified shard map target to have its credentials updated.

Examples

Example 1: Update credentials used within a shard map target

PS C:\>New-AzureSqlJobTarget -ShardMapManagerServerName "MyShardMapManagerServer.database.contoso.net" -ShardMapManagerDatabaseName "MyShardMapManagerDatabase" -ShardMapManagerCredentialName "MyUpdatedShardMapCredentials" -ShardMapName "MyShardMap"
TargetDescription               : {"ShardMapName":"MyShardMap","ShardMapManagerServerName":"MyShardMapManagerServer.database.contoso.net","ShardMapManagerDatabaseName":"MyShardMapManagerDatabase"}

ShardMapName                    : MyShardMap

ShardMapManagerServerName       : MyShardMapManagerServer.database.contoso.net

ShardMapManagerDatabaseName     : MyShardMapManagerDatabase

ShardMapManagerDatabaseTargetId : 9eb3ee50-e4b2-4feb-b2f7-3ee1cd7f7997

ShardMapManagerCredentialName   : MyUpdatedShardMapCredentials

TargetId                        : 1afd9326-1277-4344-832f-8170d0375ff7

TargetType                      : ShardMap

This command updates the credentials used to determine databases within an Elastic Scale shared map target using the provided shard map server name, database name and name

Required Parameters

-MasterDatabaseCredentialName

{{Fill MasterDatabaseCredentialName Description}}

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

Specifies the name of the server.

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

Specifies the name of the credential to use whenever connecting to the shard map database to lookup the shards within the shard map.

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

Specifies the Elastic Scale shard map database name.

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

Specifies the Elastic Scale shard map server name.

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

Specifies the Elastic Scale shard map name.

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

Optional Parameters

-AzureSqlJobConnection

Specifies the connection state object for the job. You can get the connection state object through the New-AzureSqlJobConnection cmdlet. If you do not specify this parameter, the connection state is used from a prior call to the Use-AzureSqlJobConnection cmdlet.

Type:AzureSqlJobConnection
Position:1
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-LiteralServerName

{{Fill LiteralServerName Description}}

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