Add-AzSqlElasticJobStep

Referencia

Modul:: Az.Sql

Feladatlépés hozzáadása egy feladathoz

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

Az Add-AzSqlElasticJobStep parancsmag feladatlépést ad hozzá egy feladathoz

Példák

1. példa: Lépés hozzáadása egy feladathoz

$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

Feladatlépés hozzáadása egy feladathoz

Paraméterek

-AgentName

Az ügynök neve

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

-CommandText

A parancs szövege

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

-Confirm

Jóváhagyást kér a parancsmag futtatása előtt.

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

-CredentialName

A hitelesítő adatok neve

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

-DefaultProfile

Az Azure-ral való kommunikációhoz használt hitelesítő adatok, fiók, bérlő és előfizetés.

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

-InitialRetryIntervalSeconds

A kezdeti újrapróbálkozási időköz másodperc

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

-JobName

A feladat neve

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

-MaximumRetryIntervalSeconds

A maximális újrapróbálkozási időköz másodpercben

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

-Name

A feladatlépés neve

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

-OutputCredentialName

A kimeneti hitelesítő adatok neve

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

-OutputDatabaseObject

A kimeneti adatbázis objektuma

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

-OutputDatabaseResourceId

A kimeneti adatbázis erőforrás-azonosítója

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

-OutputSchemaName

A kimeneti séma neve

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

-OutputTableName

A kimeneti tábla neve

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

-ParentObject

A feladatobjektum

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

-ParentResourceId

A feladat erőforrás-azonosítója

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

-ResourceGroupName

Az erőforráscsoport neve

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

-RetryAttempts

Az újrapróbálkozási kísérletek

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

-RetryIntervalBackoffMultiplier

A szorzó újrapróbálkozási időköze

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

-ServerName

A kiszolgáló neve

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

-StepId

A lépés azonosítója

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

-TargetGroupName

A célcsoport neve

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

-TimeoutSeconds

Időtúllépés másodpercben

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

-WhatIf

Bemutatja, mi történne a parancsmag futtatásakor. A parancsmag nem fut.

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

Bevitelek

AzureSqlElasticJobModel

Kimenetek

AzureSqlElasticJobStepModel