Get-AzureSqlJobContent

Gets content containers to run or apply across entities in a target.

Syntax

Get-AzureSqlJobContent
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [<CommonParameters>]
Get-AzureSqlJobContent
   -ContentName <String[]>
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [<CommonParameters>]

Description

The Get-AzureSqlJobContent cmdlet gets one or multiple content containers that can be run or applied across entities within a job target.

Content contains one or multiple versioned definitions. You can get versioned definitions by using the Get-AzureSqlJobContentDefinition cmdlet.

Examples

Example 1: Get all content defined in the system

PS C:\>Get-AzureSqlJobContent
ContentName                                                        ContentType
-----------                                                        -----------
MyDacpac                                                           Dacpac
MyScript                                                           Script
CreateMyTestTable                                                  Script

This command gets all content defined within the system.

Example 2: Get content for a specified name

PS C:\>Get-AzureSqlJobContent -ContentName "MyScript"
ContentName                                                        ContentType
-----------                                                        -----------
MyScript                                                           Script

This command gets content for the specified 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

-ContentName

Specifies an array that contains the content.

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