Add-AzSqlElasticJobStep
Ajoute une étape de travail à un travail
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
L’applet de commande Add-AzSqlElasticJobStep ajoute une étape de travail à un travail
Exemples
Exemple 1 : Ajoute une étape à un travail
$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
Ajoute une étape de travail à un travail
Paramètres
-AgentName
Nom de l’agent
Type: | String |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CommandText
Texte de la commande
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Vous demande une confirmation avant d’exécuter l’applet de commande.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | False |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CredentialName
Nom des informations d’identification
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
Informations d’identification, compte, locataire et abonnement utilisés pour la communication avec Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InitialRetryIntervalSeconds
Intervalle de nouvelle tentative initial en secondes
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-JobName
Nom du travail
Type: | String |
Position: | 3 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-MaximumRetryIntervalSeconds
Intervalle maximal de nouvelles tentatives en secondes
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Nom de l’étape de travail
Type: | String |
Aliases: | StepName |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-OutputCredentialName
Nom des informations d’identification de sortie
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-OutputDatabaseObject
Objet de base de données de sortie
Type: | AzureSqlDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-OutputDatabaseResourceId
ID de ressource de la base de données de sortie
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-OutputSchemaName
Nom du schéma de sortie
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-OutputTableName
Nom de la table de sortie
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ParentObject
Objet de travail
Type: | AzureSqlElasticJobModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ParentResourceId
ID de ressource de travail
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceGroupName
Nom du groupe de ressources
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-RetryAttempts
Nouvelles tentatives
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-RetryIntervalBackoffMultiplier
Multiplicateur d’interruption de l’intervalle de nouvelle tentative
Type: | Nullable<T>[Double] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
Nom du serveur
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-StepId
ID d’étape
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetGroupName
Nom du groupe cible
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TimeoutSeconds
Délai d’expiration des secondes
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Montre ce qui se passe en cas d’exécution de l’applet de commande. L’applet de commande n’est pas exécutée.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | False |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Entrées
Sorties
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