Set-AzureSqlJobTarget
Updates a job target definition.
Syntax
Set-AzureSqlJobTarget
-ServerName <String>
-MasterDatabaseCredentialName <String>
[-LiteralServerName]
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobTarget
-ShardMapManagerServerName <String>
-ShardMapManagerDatabaseName <String>
-ShardMapManagerCredentialName <String>
-ShardMapName <String>
[-LiteralServerName]
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<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
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 |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-LiteralServerName
{{Fill LiteralServerName Description}}
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-MasterDatabaseCredentialName
{{Fill MasterDatabaseCredentialName Description}}
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
Specifies the name of the server.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
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 |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ShardMapManagerDatabaseName
Specifies the Elastic Scale shard map database name.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ShardMapManagerServerName
Specifies the Elastic Scale shard map server name.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ShardMapName
Specifies the Elastic Scale shard map name.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Related Links
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for