Docs Packages
  1. Pulumi Registry
  2. Azure Native
  3. API Docs
  4. sql
  5. JobStep
azure-native logo
Azure Native v1.102.0, May 2 23

azure-native.sql.JobStep

Explore with Pulumi AI

A job step. API Version: 2020-11-01-preview.

Example Usage

Create or update a job step with all properties specified.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var jobStep = new AzureNative.Sql.JobStep("jobStep", new()
    {
        Action = new AzureNative.Sql.Inputs.JobStepActionArgs
        {
            Source = "Inline",
            Type = "TSql",
            Value = "select 2",
        },
        Credential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1",
        ExecutionOptions = new AzureNative.Sql.Inputs.JobStepExecutionOptionsArgs
        {
            InitialRetryIntervalSeconds = 11,
            MaximumRetryIntervalSeconds = 222,
            RetryAttempts = 42,
            RetryIntervalBackoffMultiplier = 3,
            TimeoutSeconds = 1234,
        },
        JobAgentName = "agent1",
        JobName = "job1",
        Output = new AzureNative.Sql.Inputs.JobStepOutputArgs
        {
            Credential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
            DatabaseName = "database3",
            ResourceGroupName = "group3",
            SchemaName = "myschema1234",
            ServerName = "server3",
            SubscriptionId = "3501b905-a848-4b5d-96e8-b253f62d735a",
            TableName = "mytable5678",
            Type = "SqlDatabase",
        },
        ResourceGroupName = "group1",
        ServerName = "server1",
        StepId = 1,
        StepName = "step1",
        TargetGroup = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewJobStep(ctx, "jobStep", &sql.JobStepArgs{
			Action: &sql.JobStepActionArgs{
				Source: pulumi.String("Inline"),
				Type:   pulumi.String("TSql"),
				Value:  pulumi.String("select 2"),
			},
			Credential: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1"),
			ExecutionOptions: &sql.JobStepExecutionOptionsArgs{
				InitialRetryIntervalSeconds:    pulumi.Int(11),
				MaximumRetryIntervalSeconds:    pulumi.Int(222),
				RetryAttempts:                  pulumi.Int(42),
				RetryIntervalBackoffMultiplier: pulumi.Float64(3),
				TimeoutSeconds:                 pulumi.Int(1234),
			},
			JobAgentName: pulumi.String("agent1"),
			JobName:      pulumi.String("job1"),
			Output: sql.JobStepOutputResponse{
				Credential:        pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0"),
				DatabaseName:      pulumi.String("database3"),
				ResourceGroupName: pulumi.String("group3"),
				SchemaName:        pulumi.String("myschema1234"),
				ServerName:        pulumi.String("server3"),
				SubscriptionId:    pulumi.String("3501b905-a848-4b5d-96e8-b253f62d735a"),
				TableName:         pulumi.String("mytable5678"),
				Type:              pulumi.String("SqlDatabase"),
			},
			ResourceGroupName: pulumi.String("group1"),
			ServerName:        pulumi.String("server1"),
			StepId:            pulumi.Int(1),
			StepName:          pulumi.String("step1"),
			TargetGroup:       pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.JobStep;
import com.pulumi.azurenative.sql.JobStepArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var jobStep = new JobStep("jobStep", JobStepArgs.builder()        
            .action(Map.ofEntries(
                Map.entry("source", "Inline"),
                Map.entry("type", "TSql"),
                Map.entry("value", "select 2")
            ))
            .credential("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1")
            .executionOptions(Map.ofEntries(
                Map.entry("initialRetryIntervalSeconds", 11),
                Map.entry("maximumRetryIntervalSeconds", 222),
                Map.entry("retryAttempts", 42),
                Map.entry("retryIntervalBackoffMultiplier", 3),
                Map.entry("timeoutSeconds", 1234)
            ))
            .jobAgentName("agent1")
            .jobName("job1")
            .output(Map.ofEntries(
                Map.entry("credential", "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0"),
                Map.entry("databaseName", "database3"),
                Map.entry("resourceGroupName", "group3"),
                Map.entry("schemaName", "myschema1234"),
                Map.entry("serverName", "server3"),
                Map.entry("subscriptionId", "3501b905-a848-4b5d-96e8-b253f62d735a"),
                Map.entry("tableName", "mytable5678"),
                Map.entry("type", "SqlDatabase")
            ))
            .resourceGroupName("group1")
            .serverName("server1")
            .stepId(1)
            .stepName("step1")
            .targetGroup("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

job_step = azure_native.sql.JobStep("jobStep",
    action=azure_native.sql.JobStepActionArgs(
        source="Inline",
        type="TSql",
        value="select 2",
    ),
    credential="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1",
    execution_options=azure_native.sql.JobStepExecutionOptionsArgs(
        initial_retry_interval_seconds=11,
        maximum_retry_interval_seconds=222,
        retry_attempts=42,
        retry_interval_backoff_multiplier=3,
        timeout_seconds=1234,
    ),
    job_agent_name="agent1",
    job_name="job1",
    output=azure_native.sql.JobStepOutputResponseArgs(
        credential="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
        database_name="database3",
        resource_group_name="group3",
        schema_name="myschema1234",
        server_name="server3",
        subscription_id="3501b905-a848-4b5d-96e8-b253f62d735a",
        table_name="mytable5678",
        type="SqlDatabase",
    ),
    resource_group_name="group1",
    server_name="server1",
    step_id=1,
    step_name="step1",
    target_group="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const jobStep = new azure_native.sql.JobStep("jobStep", {
    action: {
        source: "Inline",
        type: "TSql",
        value: "select 2",
    },
    credential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1",
    executionOptions: {
        initialRetryIntervalSeconds: 11,
        maximumRetryIntervalSeconds: 222,
        retryAttempts: 42,
        retryIntervalBackoffMultiplier: 3,
        timeoutSeconds: 1234,
    },
    jobAgentName: "agent1",
    jobName: "job1",
    output: {
        credential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
        databaseName: "database3",
        resourceGroupName: "group3",
        schemaName: "myschema1234",
        serverName: "server3",
        subscriptionId: "3501b905-a848-4b5d-96e8-b253f62d735a",
        tableName: "mytable5678",
        type: "SqlDatabase",
    },
    resourceGroupName: "group1",
    serverName: "server1",
    stepId: 1,
    stepName: "step1",
    targetGroup: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1",
});

resources:
  jobStep:
    type: azure-native:sql:JobStep
    properties:
      action:
        source: Inline
        type: TSql
        value: select 2
      credential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred1
      executionOptions:
        initialRetryIntervalSeconds: 11
        maximumRetryIntervalSeconds: 222
        retryAttempts: 42
        retryIntervalBackoffMultiplier: 3
        timeoutSeconds: 1234
      jobAgentName: agent1
      jobName: job1
      output:
        credential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0
        databaseName: database3
        resourceGroupName: group3
        schemaName: myschema1234
        serverName: server3
        subscriptionId: 3501b905-a848-4b5d-96e8-b253f62d735a
        tableName: mytable5678
        type: SqlDatabase
      resourceGroupName: group1
      serverName: server1
      stepId: 1
      stepName: step1
      targetGroup: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup1

Create or update a job step with minimal properties specified.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var jobStep = new AzureNative.Sql.JobStep("jobStep", new()
    {
        Action = new AzureNative.Sql.Inputs.JobStepActionArgs
        {
            Value = "select 1",
        },
        Credential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
        JobAgentName = "agent1",
        JobName = "job1",
        ResourceGroupName = "group1",
        ServerName = "server1",
        StepName = "step1",
        TargetGroup = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewJobStep(ctx, "jobStep", &sql.JobStepArgs{
			Action: &sql.JobStepActionArgs{
				Value: pulumi.String("select 1"),
			},
			Credential:        pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0"),
			JobAgentName:      pulumi.String("agent1"),
			JobName:           pulumi.String("job1"),
			ResourceGroupName: pulumi.String("group1"),
			ServerName:        pulumi.String("server1"),
			StepName:          pulumi.String("step1"),
			TargetGroup:       pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.JobStep;
import com.pulumi.azurenative.sql.JobStepArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var jobStep = new JobStep("jobStep", JobStepArgs.builder()        
            .action(Map.of("value", "select 1"))
            .credential("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0")
            .jobAgentName("agent1")
            .jobName("job1")
            .resourceGroupName("group1")
            .serverName("server1")
            .stepName("step1")
            .targetGroup("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

job_step = azure_native.sql.JobStep("jobStep",
    action=azure_native.sql.JobStepActionArgs(
        value="select 1",
    ),
    credential="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
    job_agent_name="agent1",
    job_name="job1",
    resource_group_name="group1",
    server_name="server1",
    step_name="step1",
    target_group="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const jobStep = new azure_native.sql.JobStep("jobStep", {
    action: {
        value: "select 1",
    },
    credential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0",
    jobAgentName: "agent1",
    jobName: "job1",
    resourceGroupName: "group1",
    serverName: "server1",
    stepName: "step1",
    targetGroup: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0",
});

resources:
  jobStep:
    type: azure-native:sql:JobStep
    properties:
      action:
        value: select 1
      credential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/cred0
      jobAgentName: agent1
      jobName: job1
      resourceGroupName: group1
      serverName: server1
      stepName: step1
      targetGroup: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/targetGroups/targetGroup0

Create JobStep Resource

new JobStep(name: string, args: JobStepArgs, opts?: CustomResourceOptions);
@overload
def JobStep(resource_name: str,
            opts: Optional[ResourceOptions] = None,
            action: Optional[JobStepActionArgs] = None,
            credential: Optional[str] = None,
            execution_options: Optional[JobStepExecutionOptionsArgs] = None,
            job_agent_name: Optional[str] = None,
            job_name: Optional[str] = None,
            output: Optional[JobStepOutputArgs] = None,
            resource_group_name: Optional[str] = None,
            server_name: Optional[str] = None,
            step_id: Optional[int] = None,
            step_name: Optional[str] = None,
            target_group: Optional[str] = None)
@overload
def JobStep(resource_name: str,
            args: JobStepArgs,
            opts: Optional[ResourceOptions] = None)
func NewJobStep(ctx *Context, name string, args JobStepArgs, opts ...ResourceOption) (*JobStep, error)
public JobStep(string name, JobStepArgs args, CustomResourceOptions? opts = null)
public JobStep(String name, JobStepArgs args)
public JobStep(String name, JobStepArgs args, CustomResourceOptions options)

type: azure-native:sql:JobStep
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
name string
The unique name of the resource.
args JobStepArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args JobStepArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args JobStepArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args JobStepArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args JobStepArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

JobStep Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The JobStep resource accepts the following input properties:

Action Pulumi.AzureNative.Sql.Inputs.JobStepActionArgs

The action payload of the job step.

Credential string

The resource ID of the job credential that will be used to connect to the targets.

JobAgentName string

The name of the job agent.

JobName string

The name of the job.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

ServerName string

The name of the server.

TargetGroup string

The resource ID of the target group that the job step will be executed on.

ExecutionOptions Pulumi.AzureNative.Sql.Inputs.JobStepExecutionOptionsArgs

Execution options for the job step.

Output Pulumi.AzureNative.Sql.Inputs.JobStepOutputArgs

Output destination properties of the job step.

StepId int

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

StepName string

The name of the job step.

Action JobStepActionArgs

The action payload of the job step.

Credential string

The resource ID of the job credential that will be used to connect to the targets.

JobAgentName string

The name of the job agent.

JobName string

The name of the job.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

ServerName string

The name of the server.

TargetGroup string

The resource ID of the target group that the job step will be executed on.

ExecutionOptions JobStepExecutionOptionsArgs

Execution options for the job step.

Output JobStepOutputTypeArgs

Output destination properties of the job step.

StepId int

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

StepName string

The name of the job step.

action JobStepActionArgs

The action payload of the job step.

credential String

The resource ID of the job credential that will be used to connect to the targets.

jobAgentName String

The name of the job agent.

jobName String

The name of the job.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName String

The name of the server.

targetGroup String

The resource ID of the target group that the job step will be executed on.

executionOptions JobStepExecutionOptionsArgs

Execution options for the job step.

output JobStepOutputArgs

Output destination properties of the job step.

stepId Integer

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

stepName String

The name of the job step.

action JobStepActionArgs

The action payload of the job step.

credential string

The resource ID of the job credential that will be used to connect to the targets.

jobAgentName string

The name of the job agent.

jobName string

The name of the job.

resourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName string

The name of the server.

targetGroup string

The resource ID of the target group that the job step will be executed on.

executionOptions JobStepExecutionOptionsArgs

Execution options for the job step.

output JobStepOutputArgs

Output destination properties of the job step.

stepId number

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

stepName string

The name of the job step.

action JobStepActionArgs

The action payload of the job step.

credential str

The resource ID of the job credential that will be used to connect to the targets.

job_agent_name str

The name of the job agent.

job_name str

The name of the job.

resource_group_name str

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

server_name str

The name of the server.

target_group str

The resource ID of the target group that the job step will be executed on.

execution_options JobStepExecutionOptionsArgs

Execution options for the job step.

output JobStepOutputArgs

Output destination properties of the job step.

step_id int

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

step_name str

The name of the job step.

action Property Map

The action payload of the job step.

credential String

The resource ID of the job credential that will be used to connect to the targets.

jobAgentName String

The name of the job agent.

jobName String

The name of the job.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName String

The name of the server.

targetGroup String

The resource ID of the target group that the job step will be executed on.

executionOptions Property Map

Execution options for the job step.

output Property Map

Output destination properties of the job step.

stepId Number

The job step's index within the job. If not specified when creating the job step, it will be created as the last step. If not specified when updating the job step, the step id is not modified.

stepName String

The name of the job step.

Outputs

All input properties are implicitly available as output properties. Additionally, the JobStep resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

Type string

Resource type.

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

Type string

Resource type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

type String

Resource type.

id string

The provider-assigned unique ID for this managed resource.

name string

Resource name.

type string

Resource type.

id str

The provider-assigned unique ID for this managed resource.

name str

Resource name.

type str

Resource type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

type String

Resource type.

Supporting Types

JobStepAction

Value string

The action value, for example the text of the T-SQL script to execute.

Source string | Pulumi.AzureNative.Sql.JobStepActionSource

The source of the action to execute.

Type string | Pulumi.AzureNative.Sql.JobStepActionType

Type of action being executed by the job step.

Value string

The action value, for example the text of the T-SQL script to execute.

Source string | JobStepActionSource

The source of the action to execute.

Type string | JobStepActionType

Type of action being executed by the job step.

value String

The action value, for example the text of the T-SQL script to execute.

source String | JobStepActionSource

The source of the action to execute.

type String | JobStepActionType

Type of action being executed by the job step.

value string

The action value, for example the text of the T-SQL script to execute.

source string | JobStepActionSource

The source of the action to execute.

type string | JobStepActionType

Type of action being executed by the job step.

value str

The action value, for example the text of the T-SQL script to execute.

source str | JobStepActionSource

The source of the action to execute.

type str | JobStepActionType

Type of action being executed by the job step.

value String

The action value, for example the text of the T-SQL script to execute.

source String | "Inline"

The source of the action to execute.

type String | "TSql"

Type of action being executed by the job step.

JobStepActionResponse

Value string

The action value, for example the text of the T-SQL script to execute.

Source string

The source of the action to execute.

Type string

Type of action being executed by the job step.

Value string

The action value, for example the text of the T-SQL script to execute.

Source string

The source of the action to execute.

Type string

Type of action being executed by the job step.

value String

The action value, for example the text of the T-SQL script to execute.

source String

The source of the action to execute.

type String

Type of action being executed by the job step.

value string

The action value, for example the text of the T-SQL script to execute.

source string

The source of the action to execute.

type string

Type of action being executed by the job step.

value str

The action value, for example the text of the T-SQL script to execute.

source str

The source of the action to execute.

type str

Type of action being executed by the job step.

value String

The action value, for example the text of the T-SQL script to execute.

source String

The source of the action to execute.

type String

Type of action being executed by the job step.

JobStepActionSource

Inline
Inline
JobStepActionSourceInline
Inline
Inline
Inline
Inline
Inline
INLINE
Inline
"Inline"
Inline

JobStepActionType

TSql
TSql
JobStepActionTypeTSql
TSql
TSql
TSql
TSql
TSql
T_SQL
TSql
"TSql"
TSql

JobStepExecutionOptions

InitialRetryIntervalSeconds int

Initial delay between retries for job step execution.

MaximumRetryIntervalSeconds int

The maximum amount of time to wait between retries for job step execution.

RetryAttempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

RetryIntervalBackoffMultiplier double

The backoff multiplier for the time between retries.

TimeoutSeconds int

Execution timeout for the job step.

InitialRetryIntervalSeconds int

Initial delay between retries for job step execution.

MaximumRetryIntervalSeconds int

The maximum amount of time to wait between retries for job step execution.

RetryAttempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

RetryIntervalBackoffMultiplier float64

The backoff multiplier for the time between retries.

TimeoutSeconds int

Execution timeout for the job step.

initialRetryIntervalSeconds Integer

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds Integer

The maximum amount of time to wait between retries for job step execution.

retryAttempts Integer

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier Double

The backoff multiplier for the time between retries.

timeoutSeconds Integer

Execution timeout for the job step.

initialRetryIntervalSeconds number

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds number

The maximum amount of time to wait between retries for job step execution.

retryAttempts number

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier number

The backoff multiplier for the time between retries.

timeoutSeconds number

Execution timeout for the job step.

initial_retry_interval_seconds int

Initial delay between retries for job step execution.

maximum_retry_interval_seconds int

The maximum amount of time to wait between retries for job step execution.

retry_attempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

retry_interval_backoff_multiplier float

The backoff multiplier for the time between retries.

timeout_seconds int

Execution timeout for the job step.

initialRetryIntervalSeconds Number

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds Number

The maximum amount of time to wait between retries for job step execution.

retryAttempts Number

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier Number

The backoff multiplier for the time between retries.

timeoutSeconds Number

Execution timeout for the job step.

JobStepExecutionOptionsResponse

InitialRetryIntervalSeconds int

Initial delay between retries for job step execution.

MaximumRetryIntervalSeconds int

The maximum amount of time to wait between retries for job step execution.

RetryAttempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

RetryIntervalBackoffMultiplier double

The backoff multiplier for the time between retries.

TimeoutSeconds int

Execution timeout for the job step.

InitialRetryIntervalSeconds int

Initial delay between retries for job step execution.

MaximumRetryIntervalSeconds int

The maximum amount of time to wait between retries for job step execution.

RetryAttempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

RetryIntervalBackoffMultiplier float64

The backoff multiplier for the time between retries.

TimeoutSeconds int

Execution timeout for the job step.

initialRetryIntervalSeconds Integer

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds Integer

The maximum amount of time to wait between retries for job step execution.

retryAttempts Integer

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier Double

The backoff multiplier for the time between retries.

timeoutSeconds Integer

Execution timeout for the job step.

initialRetryIntervalSeconds number

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds number

The maximum amount of time to wait between retries for job step execution.

retryAttempts number

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier number

The backoff multiplier for the time between retries.

timeoutSeconds number

Execution timeout for the job step.

initial_retry_interval_seconds int

Initial delay between retries for job step execution.

maximum_retry_interval_seconds int

The maximum amount of time to wait between retries for job step execution.

retry_attempts int

Maximum number of times the job step will be reattempted if the first attempt fails.

retry_interval_backoff_multiplier float

The backoff multiplier for the time between retries.

timeout_seconds int

Execution timeout for the job step.

initialRetryIntervalSeconds Number

Initial delay between retries for job step execution.

maximumRetryIntervalSeconds Number

The maximum amount of time to wait between retries for job step execution.

retryAttempts Number

Maximum number of times the job step will be reattempted if the first attempt fails.

retryIntervalBackoffMultiplier Number

The backoff multiplier for the time between retries.

timeoutSeconds Number

Execution timeout for the job step.

JobStepOutput

Credential string

The resource ID of the credential to use to connect to the output destination.

DatabaseName string

The output destination database.

ServerName string

The output destination server name.

TableName string

The output destination table.

ResourceGroupName string

The output destination resource group.

SchemaName string

The output destination schema.

SubscriptionId string

The output destination subscription id.

Type string | Pulumi.AzureNative.Sql.JobStepOutputType

The output destination type.

Credential string

The resource ID of the credential to use to connect to the output destination.

DatabaseName string

The output destination database.

ServerName string

The output destination server name.

TableName string

The output destination table.

ResourceGroupName string

The output destination resource group.

SchemaName string

The output destination schema.

SubscriptionId string

The output destination subscription id.

Type string | JobStepOutputTypeEnum

The output destination type.

credential String

The resource ID of the credential to use to connect to the output destination.

databaseName String

The output destination database.

serverName String

The output destination server name.

tableName String

The output destination table.

resourceGroupName String

The output destination resource group.

schemaName String

The output destination schema.

subscriptionId String

The output destination subscription id.

type String | JobStepOutputType

The output destination type.

credential string

The resource ID of the credential to use to connect to the output destination.

databaseName string

The output destination database.

serverName string

The output destination server name.

tableName string

The output destination table.

resourceGroupName string

The output destination resource group.

schemaName string

The output destination schema.

subscriptionId string

The output destination subscription id.

type string | JobStepOutputType

The output destination type.

credential str

The resource ID of the credential to use to connect to the output destination.

database_name str

The output destination database.

server_name str

The output destination server name.

table_name str

The output destination table.

resource_group_name str

The output destination resource group.

schema_name str

The output destination schema.

subscription_id str

The output destination subscription id.

type str | JobStepOutputType

The output destination type.

credential String

The resource ID of the credential to use to connect to the output destination.

databaseName String

The output destination database.

serverName String

The output destination server name.

tableName String

The output destination table.

resourceGroupName String

The output destination resource group.

schemaName String

The output destination schema.

subscriptionId String

The output destination subscription id.

type String | "SqlDatabase"

The output destination type.

JobStepOutputResponse

Credential string

The resource ID of the credential to use to connect to the output destination.

DatabaseName string

The output destination database.

ServerName string

The output destination server name.

TableName string

The output destination table.

ResourceGroupName string

The output destination resource group.

SchemaName string

The output destination schema.

SubscriptionId string

The output destination subscription id.

Type string

The output destination type.

Credential string

The resource ID of the credential to use to connect to the output destination.

DatabaseName string

The output destination database.

ServerName string

The output destination server name.

TableName string

The output destination table.

ResourceGroupName string

The output destination resource group.

SchemaName string

The output destination schema.

SubscriptionId string

The output destination subscription id.

Type string

The output destination type.

credential String

The resource ID of the credential to use to connect to the output destination.

databaseName String

The output destination database.

serverName String

The output destination server name.

tableName String

The output destination table.

resourceGroupName String

The output destination resource group.

schemaName String

The output destination schema.

subscriptionId String

The output destination subscription id.

type String

The output destination type.

credential string

The resource ID of the credential to use to connect to the output destination.

databaseName string

The output destination database.

serverName string

The output destination server name.

tableName string

The output destination table.

resourceGroupName string

The output destination resource group.

schemaName string

The output destination schema.

subscriptionId string

The output destination subscription id.

type string

The output destination type.

credential str

The resource ID of the credential to use to connect to the output destination.

database_name str

The output destination database.

server_name str

The output destination server name.

table_name str

The output destination table.

resource_group_name str

The output destination resource group.

schema_name str

The output destination schema.

subscription_id str

The output destination subscription id.

type str

The output destination type.

credential String

The resource ID of the credential to use to connect to the output destination.

databaseName String

The output destination database.

serverName String

The output destination server name.

tableName String

The output destination table.

resourceGroupName String

The output destination resource group.

schemaName String

The output destination schema.

subscriptionId String

The output destination subscription id.

type String

The output destination type.

JobStepOutputType

SqlDatabase
SqlDatabase
JobStepOutputTypeSqlDatabase
SqlDatabase
SqlDatabase
SqlDatabase
SqlDatabase
SqlDatabase
SQL_DATABASE
SqlDatabase
"SqlDatabase"
SqlDatabase

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:JobStep step1 /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1/steps/step1

Package Details

Repository
Azure Native pulumi/pulumi-azure-native
License
Apache-2.0