Add-AzSqlElasticJobStep

Referens

Modul:: Az.Sql

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 1

Lägger till ett jobbsteg i ett jobb

Parametrar

-AgentName

Agentnamnet

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-CommandText

Kommandotexten

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

Uppmanar dig att bekräfta innan du kör cmdleten.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-CredentialName

Namnet på autentiseringsuppgifterna

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

Autentiseringsuppgifter, konto, klientorganisation och prenumeration som används för kommunikation med Azure.

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-InitialRetryIntervalSeconds

De första återförsöksintervallssekunderna

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-JobName

Jobbnamnet

Type:	String
Position:	3
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-MaximumRetryIntervalSeconds

Det maximala återförsöksintervallet sekunder

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

Namnet på jobbsteget

Type:	String
Aliases:	StepName
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-OutputCredentialName

Utdataautentiseringsnamnet

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-OutputDatabaseObject

Utdatadatabasobjektet

Type:	AzureSqlDatabaseModel
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-OutputDatabaseResourceId

Resurs-ID för utdatadatabasen

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-OutputSchemaName

Namnet på utdataschemat

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-OutputTableName

Namnet på utdatatabellen

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ParentObject

Jobbobjektet

Type:	AzureSqlElasticJobModel
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ParentResourceId

Jobbresurs-ID:t

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ResourceGroupName

Resursgruppens namn

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-RetryAttempts

Återförsöken

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-RetryIntervalBackoffMultiplier

Återförsöksintervallet back off multiplikator

Type:	Nullable<T>[Double]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ServerName

Servernamnet

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-StepId

Steg-ID

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-TargetGroupName

Målgruppens namn

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-TimeoutSeconds

Tidsgränsen sekunder

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Visar vad som skulle hända om cmdleten kördes. Cmdleten körs inte.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Indata

AzureSqlElasticJobModel

Utdata

AzureSqlElasticJobStepModel

Dela via