Get-​Azure​Sql​Job​Task​Execution

Gets one or multiple task run results.

Syntax

Get-AzureSqlJobTaskExecution
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -JobExecutionId <Guid[]>
   [<CommonParameters>]
Get-AzureSqlJobTaskExecution
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -JobTaskExecutionId <Guid[]>
   [<CommonParameters>]

Description

The Get-AzureSqlJobTaskExecution cmdlet gets one or multiple task run results.

Examples

Example 1: Get all task executions for the specified job execution ID

PS C:\>Get-AzureSqlJobTaskExecution -JobExecutionId 07981e74-5235-48a6-b24e-b5beb16a149a
JobTaskExecutionId : ac618be9-9a9c-4308-9652-42c8420aa9a4
JobTaskType        : ScriptSplit
Lifecycle          : Failed
CreatedTime        : 7/10/2015 2:01:04 PM -07:00
StartTime          : 7/10/2015 2:01:04 PM -07:00
EndTime            : 7/10/2015 2:01:04 PM -07:00
Message            : System.AggregateException: One or more errors occurred. ---> Microsoft.Azure.SqlDatabase.Jobs.Common.UserException: An exception
                     occured while executing command on behalf of the user. See inner exception for details. ---> System.AggregateException: One or more
                     syntax errors occurred. ---> System.InvalidOperationException: 46010: Incorrect syntax near \. (Line 19, Column 16)

This command gets all task executions for the provided job execution ID.

Example 2: Get the specified job execution task

PS C:\>Get-AzureSqlJobTaskExecution -JobTaskExecutionId ac618be9-9a9c-4308-9652-42c8420aa9a4
JobTaskExecutionId : ac618be9-9a9c-4308-9652-42c8420aa9a4
JobTaskType        : ScriptSplit
Lifecycle          : Failed
CreatedTime        : 7/10/2015 2:01:04 PM -07:00
StartTime          : 7/10/2015 2:01:04 PM -07:00
EndTime            : 7/10/2015 2:01:04 PM -07:00
Message            : System.AggregateException: One or more errors occurred. ---> Microsoft.Azure.SqlDatabase.Jobs.Common.UserException: An exception
                     occured while executing command on behalf of the user. See inner exception for details. ---> System.AggregateException: One or more
                     syntax errors occurred. ---> System.InvalidOperationException: 46010: Incorrect syntax near \. (Line 19, Column 16)

This command gets the specified job execution task.

Required Parameters

-JobExecutionId

Specifies the job execution ID.

Type:Guid[]
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-JobTaskExecutionId

Specifies the job task execution ID.

Type:Guid[]
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