Add-AzSqlElasticJobStep
Lägger till ett jobbsteg i ett jobb
Syntax
Add-AzSqlElasticJobStep
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-JobName] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-Name <String>
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-JobName] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseObject <AzureSqlDatabaseModel>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-JobName] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseResourceId <String>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentObject] <AzureSqlElasticJobModel>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-Name <String>
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentObject] <AzureSqlElasticJobModel>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseObject <AzureSqlDatabaseModel>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentObject] <AzureSqlElasticJobModel>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseResourceId <String>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentResourceId] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-Name <String>
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentResourceId] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseObject <AzureSqlDatabaseModel>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-AzSqlElasticJobStep
[-ParentResourceId] <String>
-TargetGroupName <String>
[-CredentialName <String>]
-CommandText <String>
-OutputDatabaseResourceId <String>
[-OutputCredentialName <String>]
-OutputTableName <String>
-Name <String>
[-OutputSchemaName <String>]
[-StepId <Int32>]
[-TimeoutSeconds <Int32>]
[-RetryAttempts <Int32>]
[-InitialRetryIntervalSeconds <Int32>]
[-MaximumRetryIntervalSeconds <Int32>]
[-RetryIntervalBackoffMultiplier <Double>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
Cmdleten Add-AzSqlElasticJobStep lägger till ett jobbsteg i ett jobb
Exempel
Exempel 1: Lägger till ett steg i ett jobb
$job = Get-AzSqlElasticJob -ResourceGroupName rg -ServerName elasticjobserver -Name job1
$job | Add-AzSqlElasticJobStep -Name step1 -TargetGroupName tg1 -CredentialName cred1 -CommandText "SELECT 1"
JobName StepName StepId TargetGroupName CredentialName Output CommandText
------- -------- ------ --------------- -------------- ------ -----------
job1 step1 1 tg1 cred1 SELECT 1Lägger till ett jobbsteg i ett jobb
Parametrar
-AgentName
Agentnamnet
| Typ: | String |
| Position: | 2 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-CommandText
Kommandotexten
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-Confirm
Uppmanar dig att bekräfta innan du kör cmdleten.
| Typ: | SwitchParameter |
| Alias: | cf |
| Position: | Named |
| Standardvärde: | False |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-CredentialName
Namnet på autentiseringsuppgifterna
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-DefaultProfile
Autentiseringsuppgifter, konto, klientorganisation och prenumeration som används för kommunikation med Azure.
| Typ: | IAzureContextContainer |
| Alias: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-InitialRetryIntervalSeconds
De första återförsöksintervallssekunderna
| Typ: | Nullable<T>[Int32] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-JobName
Jobbnamnet
| Typ: | String |
| Position: | 3 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-MaximumRetryIntervalSeconds
Det maximala återförsöksintervallet sekunder
| Typ: | Nullable<T>[Int32] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-Name
Namnet på jobbsteget
| Typ: | String |
| Alias: | StepName |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-OutputCredentialName
Utdataautentiseringsnamnet
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-OutputDatabaseObject
Utdatadatabasobjektet
| Typ: | AzureSqlDatabaseModel |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-OutputDatabaseResourceId
Resurs-ID för utdatadatabasen
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-OutputSchemaName
Namnet på utdataschemat
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-OutputTableName
Namnet på utdatatabellen
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-ParentObject
Jobbobjektet
| Typ: | AzureSqlElasticJobModel |
| Position: | 0 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | True |
| Godkänn jokertecken: | False |
-ParentResourceId
Jobbresurs-ID:t
| Typ: | String |
| Position: | 0 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | True |
| Godkänn jokertecken: | False |
-ResourceGroupName
Resursgruppens namn
| Typ: | String |
| Position: | 0 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-RetryAttempts
Återförsöken
| Typ: | Nullable<T>[Int32] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-RetryIntervalBackoffMultiplier
Återförsöksintervallet back off multiplikator
| Typ: | Nullable<T>[Double] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-ServerName
Servernamnet
| Typ: | String |
| Position: | 1 |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-StepId
Steg-ID
| Typ: | Nullable<T>[Int32] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-TargetGroupName
Målgruppens namn
| Typ: | String |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | True |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-TimeoutSeconds
Tidsgränsen sekunder
| Typ: | Nullable<T>[Int32] |
| Position: | Named |
| Standardvärde: | None |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
-WhatIf
Visar vad som skulle hända om cmdleten körs. Cmdleten körs inte.
| Typ: | SwitchParameter |
| Alias: | wi |
| Position: | Named |
| Standardvärde: | False |
| Obligatorisk: | False |
| Godkänn pipeline-indata: | False |
| Godkänn jokertecken: | False |
Indata
Utdata
Samarbeta med oss på GitHub
Källan för det här innehållet finns på GitHub, där du även kan skapa och granska ärenden och pull-begäranden. Se vår deltagarguide för mer information.
Azure PowerShell