Get-AzureSqlJobTaskExecution
Gets one or multiple task run results.
Syntax
Get-AzureSqlJobTaskExecution
-JobExecutionId <Guid[]>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Get-AzureSqlJobTaskExecution
-JobTaskExecutionId <Guid[]>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<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.
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 |
-JobExecutionId
Specifies the job execution ID.
Type: | Guid[] |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-JobTaskExecutionId
Specifies the job task execution ID.
Type: | Guid[] |
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