Get-AzSqlElasticJobExecution
Gets one or more job executions
Syntax
DefaultSet (Default)
Get-AzSqlElasticJobExecution
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-Count] <Int32>
[-JobName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
WithJobExecutionId
Get-AzSqlElasticJobExecution
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
-JobName <String>
-JobExecutionId <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
ObjectSet
Get-AzSqlElasticJobExecution
[-ParentObject] <AzureSqlElasticJobAgentModel>
[-Count] <Int32>
[-JobName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
WithJobExecutionIdUsingParentObject
Get-AzSqlElasticJobExecution
[-ParentObject] <AzureSqlElasticJobAgentModel>
-JobName <String>
-JobExecutionId <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
ResourceIdSet
Get-AzSqlElasticJobExecution
[-ParentResourceId] <String>
[-Count] <Int32>
[-JobName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
WithJobExecutionIdUsingParentResourceId
Get-AzSqlElasticJobExecution
[-ParentResourceId] <String>
-JobName <String>
-JobExecutionId <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
The Get-AzSqlElasticJobExecution cmdlet gets one or more job executions
Examples
Example 1: Gets one or more job executions across all jobs
$agent = Get-AzSqlElasticJobAgent -ResourceGroupName rg -ServerName elasticjobserver -Name agent
$agent | Get-AzSqlElasticJobExecution -Count 3
JobName JobExecutionId Lifecycle StartTime EndTime
------- -------------- --------- --------- -------
job1 dab0ebe8-fd52-42e9-bacf-e5f27577039b Canceled 6/1/2018 10:13:56 PM 6/1/2018 10:13:59 PM
job1 3bcfc912-20b2-411d-a2b7-6265d13fe272 Succeeded 6/1/2018 10:11:43 PM 6/1/2018 10:11:47 PM
job2 433f798e-f35c-41de-a23c-f2b43801d7b4 Succeeded 6/1/2018 10:11:36 PM 6/1/2018 10:11:41 PM
Example 2: Gets one or more job executions for a job
$agent = Get-AzSqlElasticJobAgent -ResourceGroupName rg -ServerName elasticjobserver -Name agent
$agent | Get-AzSqlElasticJobExecution -Count 3 -JobName job2
JobName JobExecutionId Lifecycle StartTime EndTime
------- -------------- --------- --------- -------
job2 433f798e-f35c-41de-a23c-f2b43801d7b4 Succeeded 6/1/2018 10:11:36 PM 6/1/2018 10:11:41 PM
Gets one or more job executions
Example 3
Gets one or more job executions. (autogenerated)
Get-AzSqlElasticJobExecution -JobExecutionId 00000000-0000-0000-0000-000000000000 -JobName job1
Parameters
-Active
Filter by create time min
Parameter properties
Type: SwitchParameter
Default value: False Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-AgentName
The agent name.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: 2 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionId
Position: 2 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-Count
Count returns the top number of executions.
Parameter properties
Type: Nullable<T> [ Int32 ]
Default value: None Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: 3 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: 3 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: 3 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-CreateTimeMax
Filter by create time min
Parameter properties
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-CreateTimeMin
Filter by create time min
Parameter properties
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
Parameter properties
Type: IAzureContextContainer
Default value: None Supports wildcards: False DontShow: False Aliases: AzContext, AzureRmContext, AzureCredential
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-EndTimeMax
Filter by create time min
Parameter properties
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-EndTimeMin
Filter by create time min
Parameter properties
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-JobExecutionId
The job execution id.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
WithJobExecutionId
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionIdUsingParentObject
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionIdUsingParentResourceId
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-JobName
The job name.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ObjectSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
ResourceIdSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-ParentObject
The job execution id.
Parameter properties
Parameter sets
ObjectSet
Position: 0 Mandatory: True Value from pipeline: True Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionIdUsingParentObject
Position: 0 Mandatory: True Value from pipeline: True Value from pipeline by property name: False Value from remaining arguments: False
-ParentResourceId
The agent resource id.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
ResourceIdSet
Position: 0 Mandatory: True Value from pipeline: False Value from pipeline by property name: True Value from remaining arguments: False
WithJobExecutionIdUsingParentResourceId
Position: 0 Mandatory: True Value from pipeline: False Value from pipeline by property name: True Value from remaining arguments: False
-ResourceGroupName
The resource group name.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: 0 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionId
Position: 0 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-ServerName
The server name.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
DefaultSet
Position: 1 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
WithJobExecutionId
Position: 1 Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable,
-InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable,
-ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see
about_CommonParameters .
Outputs
