Get-​Azure​Sql​Job​Credential

Gets one or multiple database credentials to use when connecting to databases for execution of jobs.

Syntax

Get-AzureSqlJobCredential
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -CredentialName <String[]>
   [<CommonParameters>]

Description

The Get-AzureSqlJobCredential cmdlet gets one or multiple database credentials to use when connecting to databases for execution of jobs. Passwords are encrypted prior to transmission within creation and are not returned through get requests.

Examples

Example 1: Get the credential stored within the system using the provided name

PS C:\>Get-AzureSqlJobCredential -CredentialName MyCredential
CredentialName                                              UserName
--------------                                              --------
MyCredential                                                MyUsername

This command gets the credential stored within the system using the provided name.

Example 2: Get all credentials stored within the system

PS C:\>Get-AzureSqlJobCredential
CredentialName                                              UserName
--------------                                              --------
MyCredential                                                MyUsername
MyCredential2                                               MyUsername2

Get all credentials stored within the system.

Required Parameters

-CredentialName

Specifies the name of the credential.

Type:String[]
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
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