Docs Packages
  1. Packages
  2. Azure Native v1
  3. API Docs
  4. sql
  5. JobStep
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

azure-native.sql.JobStep

Explore with Pulumi AI

azure-native-v1 logo
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

    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 System.Linq;
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/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.JobStepOutputTypeArgs{
				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.JobStepOutputArgs(
        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 System.Linq;
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/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

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new JobStep(name: string, args: JobStepArgs, opts?: CustomResourceOptions);
    @overload
def JobStep(resource_name: str,
            args: JobStepArgs,
            opts: Optional[ResourceOptions] = None)

@overload
def JobStep(resource_name: str,
            opts: Optional[ResourceOptions] = None,
            action: Optional[JobStepActionArgs] = None,
            credential: Optional[str] = None,
            job_agent_name: Optional[str] = None,
            job_name: Optional[str] = None,
            resource_group_name: Optional[str] = None,
            server_name: Optional[str] = None,
            target_group: Optional[str] = None,
            execution_options: Optional[JobStepExecutionOptionsArgs] = None,
            output: Optional[JobStepOutputArgs] = None,
            step_id: Optional[int] = None,
            step_name: Optional[str] = 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.

    Parameters

    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.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var jobStepResource = new AzureNative.Sql.JobStep("jobStepResource", new()
{
    Action = 
    {
        { "value", "string" },
        { "source", "string" },
        { "type", "string" },
    },
    Credential = "string",
    JobAgentName = "string",
    JobName = "string",
    ResourceGroupName = "string",
    ServerName = "string",
    TargetGroup = "string",
    ExecutionOptions = 
    {
        { "initialRetryIntervalSeconds", 0 },
        { "maximumRetryIntervalSeconds", 0 },
        { "retryAttempts", 0 },
        { "retryIntervalBackoffMultiplier", 0 },
        { "timeoutSeconds", 0 },
    },
    Output = 
    {
        { "credential", "string" },
        { "databaseName", "string" },
        { "serverName", "string" },
        { "tableName", "string" },
        { "resourceGroupName", "string" },
        { "schemaName", "string" },
        { "subscriptionId", "string" },
        { "type", "string" },
    },
    StepId = 0,
    StepName = "string",
});

    example, err := sql.NewJobStep(ctx, "jobStepResource", &sql.JobStepArgs{
	Action: map[string]interface{}{
		"value":  "string",
		"source": "string",
		"type":   "string",
	},
	Credential:        "string",
	JobAgentName:      "string",
	JobName:           "string",
	ResourceGroupName: "string",
	ServerName:        "string",
	TargetGroup:       "string",
	ExecutionOptions: map[string]interface{}{
		"initialRetryIntervalSeconds":    0,
		"maximumRetryIntervalSeconds":    0,
		"retryAttempts":                  0,
		"retryIntervalBackoffMultiplier": 0,
		"timeoutSeconds":                 0,
	},
	Output: map[string]interface{}{
		"credential":        "string",
		"databaseName":      "string",
		"serverName":        "string",
		"tableName":         "string",
		"resourceGroupName": "string",
		"schemaName":        "string",
		"subscriptionId":    "string",
		"type":              "string",
	},
	StepId:   0,
	StepName: "string",
})

    var jobStepResource = new JobStep("jobStepResource", JobStepArgs.builder()
    .action(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .credential("string")
    .jobAgentName("string")
    .jobName("string")
    .resourceGroupName("string")
    .serverName("string")
    .targetGroup("string")
    .executionOptions(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .output(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .stepId(0)
    .stepName("string")
    .build());

    job_step_resource = azure_native.sql.JobStep("jobStepResource",
    action={
        value: string,
        source: string,
        type: string,
    },
    credential=string,
    job_agent_name=string,
    job_name=string,
    resource_group_name=string,
    server_name=string,
    target_group=string,
    execution_options={
        initialRetryIntervalSeconds: 0,
        maximumRetryIntervalSeconds: 0,
        retryAttempts: 0,
        retryIntervalBackoffMultiplier: 0,
        timeoutSeconds: 0,
    },
    output={
        credential: string,
        databaseName: string,
        serverName: string,
        tableName: string,
        resourceGroupName: string,
        schemaName: string,
        subscriptionId: string,
        type: string,
    },
    step_id=0,
    step_name=string)

    const jobStepResource = new azure_native.sql.JobStep("jobStepResource", {
    action: {
        value: "string",
        source: "string",
        type: "string",
    },
    credential: "string",
    jobAgentName: "string",
    jobName: "string",
    resourceGroupName: "string",
    serverName: "string",
    targetGroup: "string",
    executionOptions: {
        initialRetryIntervalSeconds: 0,
        maximumRetryIntervalSeconds: 0,
        retryAttempts: 0,
        retryIntervalBackoffMultiplier: 0,
        timeoutSeconds: 0,
    },
    output: {
        credential: "string",
        databaseName: "string",
        serverName: "string",
        tableName: "string",
        resourceGroupName: "string",
        schemaName: "string",
        subscriptionId: "string",
        type: "string",
    },
    stepId: 0,
    stepName: "string",
});

    type: azure-native:sql:JobStep
properties:
    action:
        source: string
        type: string
        value: string
    credential: string
    executionOptions:
        initialRetryIntervalSeconds: 0
        maximumRetryIntervalSeconds: 0
        retryAttempts: 0
        retryIntervalBackoffMultiplier: 0
        timeoutSeconds: 0
    jobAgentName: string
    jobName: string
    output:
        credential: string
        databaseName: string
        resourceGroupName: string
        schemaName: string
        serverName: string
        subscriptionId: string
        tableName: string
        type: string
    resourceGroupName: string
    serverName: string
    stepId: 0
    stepName: string
    targetGroup: string

    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.JobStepAction
    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.JobStepExecutionOptions
    Execution options for the job step.
    Output Pulumi.AzureNative.Sql.Inputs.JobStepOutput
    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 JobStepAction
    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 JobStepExecutionOptions
    Execution options for the job step.
    output JobStepOutput
    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 JobStepAction
    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 JobStepExecutionOptions
    Execution options for the job step.
    output JobStepOutput
    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, JobStepActionArgs

    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, JobStepActionResponseArgs

    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, JobStepActionSourceArgs

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

    JobStepActionType, JobStepActionTypeArgs

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

    JobStepExecutionOptions, JobStepExecutionOptionsArgs

    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, JobStepExecutionOptionsResponseArgs

    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, JobStepOutputArgs

    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, JobStepOutputResponseArgs

    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, JobStepOutputTypeArgs

    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

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    azure-native-v1 pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native-v1 logo
    These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
    Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
    pulumi/pulumi-azure-native