Udostępnij za pośrednictwem


Add-AzSqlElasticJobStep

Dodaje krok zadania do zadania

Składnia

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>]

Opis

Polecenie cmdlet Add-AzSqlElasticJobStep dodaje krok zadania do zadania

Przykłady

Przykład 1. Dodawanie kroku do zadania

$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 1

Dodaje krok zadania do zadania

Parametry

-AgentName

Nazwa agenta

Typ:String
Position:2
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-CommandText

Tekst polecenia

Typ:String
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-Confirm

Monituje o potwierdzenie przed uruchomieniem polecenia cmdlet.

Typ:SwitchParameter
Aliases:cf
Position:Named
wartość domyślna:False
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-CredentialName

Nazwa poświadczeń

Typ:String
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-DefaultProfile

Poświadczenia, konto, dzierżawa i subskrypcja używane do komunikacji z platformą Azure.

Typ:IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-InitialRetryIntervalSeconds

Początkowy interwał ponawiania prób w sekundach

Typ:Nullable<T>[Int32]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-JobName

Nazwa zadania

Typ:String
Position:3
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-MaximumRetryIntervalSeconds

Maksymalny interwał ponawiania prób w sekundach

Typ:Nullable<T>[Int32]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-Name

Nazwa kroku zadania

Typ:String
Aliases:StepName
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-OutputCredentialName

Nazwa poświadczenia wyjściowego

Typ:String
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-OutputDatabaseObject

Obiekt wyjściowej bazy danych

Typ:AzureSqlDatabaseModel
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-OutputDatabaseResourceId

Identyfikator zasobu wyjściowej bazy danych

Typ:String
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-OutputSchemaName

Nazwa schematu wyjściowego

Typ:String
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-OutputTableName

Nazwa tabeli wyjściowej

Typ:String
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-ParentObject

Obiekt zadania

Typ:AzureSqlElasticJobModel
Position:0
wartość domyślna:None
Wymagane:True
Accept pipeline input:True
Accept wildcard characters:False

-ParentResourceId

Identyfikator zasobu zadania

Typ:String
Position:0
wartość domyślna:None
Wymagane:True
Accept pipeline input:True
Accept wildcard characters:False

-ResourceGroupName

Nazwa grupy zasobów

Typ:String
Position:0
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-RetryAttempts

Próby ponowienia próby

Typ:Nullable<T>[Int32]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-RetryIntervalBackoffMultiplier

Retry interval back off mnożnik

Typ:Nullable<T>[Double]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-ServerName

Nazwa serwera

Typ:String
Position:1
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-StepId

Identyfikator kroku

Typ:Nullable<T>[Int32]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-TargetGroupName

Nazwa grupy docelowej

Typ:String
Position:Named
wartość domyślna:None
Wymagane:True
Accept pipeline input:False
Accept wildcard characters:False

-TimeoutSeconds

Limit czasu w sekundach

Typ:Nullable<T>[Int32]
Position:Named
wartość domyślna:None
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

-WhatIf

Pokazuje, co się stanie po uruchomieniu polecenia cmdlet. Polecenie cmdlet nie zostało uruchomione.

Typ:SwitchParameter
Aliases:wi
Position:Named
wartość domyślna:False
Wymagane:False
Accept pipeline input:False
Accept wildcard characters:False

Dane wejściowe

AzureSqlElasticJobModel

Dane wyjściowe

AzureSqlElasticJobStepModel