你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
Get-AzSqlElasticJobTargetExecution
Gets one or more job target executions
Syntax
Get-AzSqlElasticJobTargetExecution
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-JobName] <String>
-JobExecutionId <String>
-Count <Int32>
[-StepName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSqlElasticJobTargetExecution
[-ParentObject] <AzureSqlElasticJobExecutionModel>
-Count <Int32>
[-StepName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSqlElasticJobTargetExecution
[-ParentResourceId] <String>
-Count <Int32>
[-StepName <String>]
[-CreateTimeMin <DateTime>]
[-CreateTimeMax <DateTime>]
[-EndTimeMin <DateTime>]
[-EndTimeMax <DateTime>]
[-Active]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Description
The Get-AzSqlElasticJobTargetExecution cmdlet gets one or more job target executions from a job execution
Examples
Example 1: Gets one or more job target executions from a job executions
$je = Get-AzSqlElasticJobExecution -ResourceGroupName rg -ServerName elasticjobserver -AgentName agent -JobName job1 -JobExecutionId 3bcfc912-20b2-411d-a2b7-6265d13fe272
$je | Get-AzSqlElasticJobTargetExecution -Count 2
JobName JobVersion StepName StepId JobExecutionId Lifecycle TargetServerName TargetDatabaseName StartTime EndTime
------- ---------- -------- ------ -------------- --------- ---------------- ------------------ --------- -------
job1 1 step2 1 ea0a870b-dfe3-427e-9f95-d229d7815b65 Succeeded s1 db2 6/1/2018 10:11:47 PM 6/1/2018 10:11:50 PM
job1 1 step1 1 ea0a870b-dfe3-427e-9f95-d229d7815b65 Succeeded s1 db1 6/1/2018 10:11:44 PM 6/1/2018 10:11:47 PMExample 2: Gets one or more job target executions from a job executions - filtering by step name
$je = Get-AzSqlElasticJobExecution -ResourceGroupName rg -ServerName elasticjobserver -AgentName agent -JobName job1 -JobExecutionId 3bcfc912-20b2-411d-a2b7-6265d13fe272
$je | Get-AzSqlElasticJobTargetExecution -Count 2 -StepName step2
JobName JobVersion StepName StepId JobExecutionId Lifecycle TargetServerName TargetDatabaseName StartTime EndTime
------- ---------- -------- ------ -------------- --------- ---------------- ------------------ --------- -------
job1 1 step2 1 ea0a870b-dfe3-427e-9f95-d229d7815b65 Succeeded s1 db2 6/1/2018 10:11:47 PM 6/1/2018 10:11:50 PMGets one or more job target executions
Parameters
-Active
Flag to filter by active executions.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AgentName
The agent name.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Count
Count returns the top number of executions.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-CreateTimeMax
Filter by create time max
| Type: | Nullable<T>[DateTime] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-CreateTimeMin
Filter by create time min
| Type: | Nullable<T>[DateTime] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-EndTimeMax
Filter by end time max.
| Type: | Nullable<T>[DateTime] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-EndTimeMin
Filter by end time min.
| Type: | Nullable<T>[DateTime] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-JobExecutionId
The job execution id.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-JobName
The job name.
| Type: | String |
| Position: | 3 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ParentObject
The job execution object.
| Type: | AzureSqlElasticJobExecutionModel |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ParentResourceId
The job execution resource id.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ResourceGroupName
The resource group name.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ServerName
The server name.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-StepName
The job step name.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Inputs
AzureSqlElasticJobExecutionModel
