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 PM
Example 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 PM
Gets 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
Outputs
Commentaires
https://aka.ms/ContentUserFeedback.
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultezEnvoyer et afficher des commentaires pour