Get-AzureSqlJobScriptBatchExecution

  • Reference
Module:
ElasticDatabaseJobs

Gets one or multiple results of a script batch execution within a task execution.

Syntax

Get-AzureSqlJobScriptBatchExecution
   -JobTaskExecutionId <Guid[]>
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [<CommonParameters>]

Description

The Get-AzureSqlJobScriptBatchExecution cmdlet gets one or multiple results of a script batch run within a task execution. Each task run for script execution also create one or multiple script batch executions.

Examples

Example 1: Get the results of execution from each batch within a script

PS C:\>Get-AzureSqlJobScriptBatchExecution -JobTaskExecutionId fd3be7b5-f860-4068-93b1-4a3b2d7c3ef3
ScriptBatchNumber : 0
Lifecycle         : Succeeded
StartTime         : 7/10/2015 3:32:07 PM -07:00
EndTime           : 7/10/2015 3:32:08 PM -07:00
Message           :

This command gets the results of the specified job task execution from each batch within a script. The job task execution ID must match a job task of type ScriptExecution.

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

-JobTaskExecutionId

Specifies the job task execution ID to use for lookup of script batch executions.

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