azure-native.sql.JobTargetGroup
Explore with Pulumi AI
A group of job targets. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview.
Other available API versions: 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview.
Example Usage
Create or update a target group with all properties.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() => 
{
    var jobTargetGroup = new AzureNative.Sql.JobTargetGroup("jobTargetGroup", new()
    {
        JobAgentName = "agent1",
        Members = new[]
        {
            new AzureNative.Sql.Inputs.JobTargetArgs
            {
                DatabaseName = "database1",
                MembershipType = AzureNative.Sql.JobTargetGroupMembershipType.Exclude,
                ServerName = "server1",
                Type = AzureNative.Sql.JobTargetType.SqlDatabase,
            },
            new AzureNative.Sql.Inputs.JobTargetArgs
            {
                MembershipType = AzureNative.Sql.JobTargetGroupMembershipType.Include,
                RefreshCredential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
                ServerName = "server1",
                Type = AzureNative.Sql.JobTargetType.SqlServer,
            },
            new AzureNative.Sql.Inputs.JobTargetArgs
            {
                ElasticPoolName = "pool1",
                MembershipType = AzureNative.Sql.JobTargetGroupMembershipType.Include,
                RefreshCredential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
                ServerName = "server2",
                Type = AzureNative.Sql.JobTargetType.SqlElasticPool,
            },
            new AzureNative.Sql.Inputs.JobTargetArgs
            {
                MembershipType = AzureNative.Sql.JobTargetGroupMembershipType.Include,
                RefreshCredential = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
                ServerName = "server3",
                ShardMapName = "shardMap1",
                Type = AzureNative.Sql.JobTargetType.SqlShardMap,
            },
        },
        ResourceGroupName = "group1",
        ServerName = "server1",
        TargetGroupName = "targetGroup1",
    });
});
package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewJobTargetGroup(ctx, "jobTargetGroup", &sql.JobTargetGroupArgs{
			JobAgentName: pulumi.String("agent1"),
			Members: sql.JobTargetArray{
				&sql.JobTargetArgs{
					DatabaseName:   pulumi.String("database1"),
					MembershipType: sql.JobTargetGroupMembershipTypeExclude,
					ServerName:     pulumi.String("server1"),
					Type:           pulumi.String(sql.JobTargetTypeSqlDatabase),
				},
				&sql.JobTargetArgs{
					MembershipType:    sql.JobTargetGroupMembershipTypeInclude,
					RefreshCredential: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential"),
					ServerName:        pulumi.String("server1"),
					Type:              pulumi.String(sql.JobTargetTypeSqlServer),
				},
				&sql.JobTargetArgs{
					ElasticPoolName:   pulumi.String("pool1"),
					MembershipType:    sql.JobTargetGroupMembershipTypeInclude,
					RefreshCredential: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential"),
					ServerName:        pulumi.String("server2"),
					Type:              pulumi.String(sql.JobTargetTypeSqlElasticPool),
				},
				&sql.JobTargetArgs{
					MembershipType:    sql.JobTargetGroupMembershipTypeInclude,
					RefreshCredential: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential"),
					ServerName:        pulumi.String("server3"),
					ShardMapName:      pulumi.String("shardMap1"),
					Type:              pulumi.String(sql.JobTargetTypeSqlShardMap),
				},
			},
			ResourceGroupName: pulumi.String("group1"),
			ServerName:        pulumi.String("server1"),
			TargetGroupName:   pulumi.String("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.JobTargetGroup;
import com.pulumi.azurenative.sql.JobTargetGroupArgs;
import com.pulumi.azurenative.sql.inputs.JobTargetArgs;
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 jobTargetGroup = new JobTargetGroup("jobTargetGroup", JobTargetGroupArgs.builder()
            .jobAgentName("agent1")
            .members(            
                JobTargetArgs.builder()
                    .databaseName("database1")
                    .membershipType("Exclude")
                    .serverName("server1")
                    .type("SqlDatabase")
                    .build(),
                JobTargetArgs.builder()
                    .membershipType("Include")
                    .refreshCredential("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential")
                    .serverName("server1")
                    .type("SqlServer")
                    .build(),
                JobTargetArgs.builder()
                    .elasticPoolName("pool1")
                    .membershipType("Include")
                    .refreshCredential("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential")
                    .serverName("server2")
                    .type("SqlElasticPool")
                    .build(),
                JobTargetArgs.builder()
                    .membershipType("Include")
                    .refreshCredential("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential")
                    .serverName("server3")
                    .shardMapName("shardMap1")
                    .type("SqlShardMap")
                    .build())
            .resourceGroupName("group1")
            .serverName("server1")
            .targetGroupName("targetGroup1")
            .build());
    }
}
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const jobTargetGroup = new azure_native.sql.JobTargetGroup("jobTargetGroup", {
    jobAgentName: "agent1",
    members: [
        {
            databaseName: "database1",
            membershipType: azure_native.sql.JobTargetGroupMembershipType.Exclude,
            serverName: "server1",
            type: azure_native.sql.JobTargetType.SqlDatabase,
        },
        {
            membershipType: azure_native.sql.JobTargetGroupMembershipType.Include,
            refreshCredential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            serverName: "server1",
            type: azure_native.sql.JobTargetType.SqlServer,
        },
        {
            elasticPoolName: "pool1",
            membershipType: azure_native.sql.JobTargetGroupMembershipType.Include,
            refreshCredential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            serverName: "server2",
            type: azure_native.sql.JobTargetType.SqlElasticPool,
        },
        {
            membershipType: azure_native.sql.JobTargetGroupMembershipType.Include,
            refreshCredential: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            serverName: "server3",
            shardMapName: "shardMap1",
            type: azure_native.sql.JobTargetType.SqlShardMap,
        },
    ],
    resourceGroupName: "group1",
    serverName: "server1",
    targetGroupName: "targetGroup1",
});
import pulumi
import pulumi_azure_native as azure_native
job_target_group = azure_native.sql.JobTargetGroup("jobTargetGroup",
    job_agent_name="agent1",
    members=[
        {
            "database_name": "database1",
            "membership_type": azure_native.sql.JobTargetGroupMembershipType.EXCLUDE,
            "server_name": "server1",
            "type": azure_native.sql.JobTargetType.SQL_DATABASE,
        },
        {
            "membership_type": azure_native.sql.JobTargetGroupMembershipType.INCLUDE,
            "refresh_credential": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            "server_name": "server1",
            "type": azure_native.sql.JobTargetType.SQL_SERVER,
        },
        {
            "elastic_pool_name": "pool1",
            "membership_type": azure_native.sql.JobTargetGroupMembershipType.INCLUDE,
            "refresh_credential": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            "server_name": "server2",
            "type": azure_native.sql.JobTargetType.SQL_ELASTIC_POOL,
        },
        {
            "membership_type": azure_native.sql.JobTargetGroupMembershipType.INCLUDE,
            "refresh_credential": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential",
            "server_name": "server3",
            "shard_map_name": "shardMap1",
            "type": azure_native.sql.JobTargetType.SQL_SHARD_MAP,
        },
    ],
    resource_group_name="group1",
    server_name="server1",
    target_group_name="targetGroup1")
resources:
  jobTargetGroup:
    type: azure-native:sql:JobTargetGroup
    properties:
      jobAgentName: agent1
      members:
        - databaseName: database1
          membershipType: Exclude
          serverName: server1
          type: SqlDatabase
        - membershipType: Include
          refreshCredential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential
          serverName: server1
          type: SqlServer
        - elasticPoolName: pool1
          membershipType: Include
          refreshCredential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential
          serverName: server2
          type: SqlElasticPool
        - membershipType: Include
          refreshCredential: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/credentials/testCredential
          serverName: server3
          shardMapName: shardMap1
          type: SqlShardMap
      resourceGroupName: group1
      serverName: server1
      targetGroupName: targetGroup1
Create or update a target group with minimal properties.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() => 
{
    var jobTargetGroup = new AzureNative.Sql.JobTargetGroup("jobTargetGroup", new()
    {
        JobAgentName = "agent1",
        Members = new[] {},
        ResourceGroupName = "group1",
        ServerName = "server1",
        TargetGroupName = "targetGroup1",
    });
});
package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewJobTargetGroup(ctx, "jobTargetGroup", &sql.JobTargetGroupArgs{
			JobAgentName:      pulumi.String("agent1"),
			Members:           sql.JobTargetArray{},
			ResourceGroupName: pulumi.String("group1"),
			ServerName:        pulumi.String("server1"),
			TargetGroupName:   pulumi.String("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.JobTargetGroup;
import com.pulumi.azurenative.sql.JobTargetGroupArgs;
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 jobTargetGroup = new JobTargetGroup("jobTargetGroup", JobTargetGroupArgs.builder()
            .jobAgentName("agent1")
            .members()
            .resourceGroupName("group1")
            .serverName("server1")
            .targetGroupName("targetGroup1")
            .build());
    }
}
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const jobTargetGroup = new azure_native.sql.JobTargetGroup("jobTargetGroup", {
    jobAgentName: "agent1",
    members: [],
    resourceGroupName: "group1",
    serverName: "server1",
    targetGroupName: "targetGroup1",
});
import pulumi
import pulumi_azure_native as azure_native
job_target_group = azure_native.sql.JobTargetGroup("jobTargetGroup",
    job_agent_name="agent1",
    members=[],
    resource_group_name="group1",
    server_name="server1",
    target_group_name="targetGroup1")
resources:
  jobTargetGroup:
    type: azure-native:sql:JobTargetGroup
    properties:
      jobAgentName: agent1
      members: []
      resourceGroupName: group1
      serverName: server1
      targetGroupName: targetGroup1
Create JobTargetGroup Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new JobTargetGroup(name: string, args: JobTargetGroupArgs, opts?: CustomResourceOptions);@overload
def JobTargetGroup(resource_name: str,
                   args: JobTargetGroupArgs,
                   opts: Optional[ResourceOptions] = None)
@overload
def JobTargetGroup(resource_name: str,
                   opts: Optional[ResourceOptions] = None,
                   job_agent_name: Optional[str] = None,
                   members: Optional[Sequence[JobTargetArgs]] = None,
                   resource_group_name: Optional[str] = None,
                   server_name: Optional[str] = None,
                   target_group_name: Optional[str] = None)func NewJobTargetGroup(ctx *Context, name string, args JobTargetGroupArgs, opts ...ResourceOption) (*JobTargetGroup, error)public JobTargetGroup(string name, JobTargetGroupArgs args, CustomResourceOptions? opts = null)
public JobTargetGroup(String name, JobTargetGroupArgs args)
public JobTargetGroup(String name, JobTargetGroupArgs args, CustomResourceOptions options)
type: azure-native:sql:JobTargetGroup
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 JobTargetGroupArgs
- 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 JobTargetGroupArgs
- 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 JobTargetGroupArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args JobTargetGroupArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args JobTargetGroupArgs
- 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 jobTargetGroupResource = new AzureNative.Sql.JobTargetGroup("jobTargetGroupResource", new()
{
    JobAgentName = "string",
    Members = new[]
    {
        new AzureNative.Sql.Inputs.JobTargetArgs
        {
            Type = "string",
            DatabaseName = "string",
            ElasticPoolName = "string",
            MembershipType = AzureNative.Sql.JobTargetGroupMembershipType.Include,
            RefreshCredential = "string",
            ServerName = "string",
            ShardMapName = "string",
        },
    },
    ResourceGroupName = "string",
    ServerName = "string",
    TargetGroupName = "string",
});
example, err := sql.NewJobTargetGroup(ctx, "jobTargetGroupResource", &sql.JobTargetGroupArgs{
	JobAgentName: pulumi.String("string"),
	Members: sql.JobTargetArray{
		&sql.JobTargetArgs{
			Type:              pulumi.String("string"),
			DatabaseName:      pulumi.String("string"),
			ElasticPoolName:   pulumi.String("string"),
			MembershipType:    sql.JobTargetGroupMembershipTypeInclude,
			RefreshCredential: pulumi.String("string"),
			ServerName:        pulumi.String("string"),
			ShardMapName:      pulumi.String("string"),
		},
	},
	ResourceGroupName: pulumi.String("string"),
	ServerName:        pulumi.String("string"),
	TargetGroupName:   pulumi.String("string"),
})
var jobTargetGroupResource = new JobTargetGroup("jobTargetGroupResource", JobTargetGroupArgs.builder()
    .jobAgentName("string")
    .members(JobTargetArgs.builder()
        .type("string")
        .databaseName("string")
        .elasticPoolName("string")
        .membershipType("Include")
        .refreshCredential("string")
        .serverName("string")
        .shardMapName("string")
        .build())
    .resourceGroupName("string")
    .serverName("string")
    .targetGroupName("string")
    .build());
job_target_group_resource = azure_native.sql.JobTargetGroup("jobTargetGroupResource",
    job_agent_name="string",
    members=[{
        "type": "string",
        "database_name": "string",
        "elastic_pool_name": "string",
        "membership_type": azure_native.sql.JobTargetGroupMembershipType.INCLUDE,
        "refresh_credential": "string",
        "server_name": "string",
        "shard_map_name": "string",
    }],
    resource_group_name="string",
    server_name="string",
    target_group_name="string")
const jobTargetGroupResource = new azure_native.sql.JobTargetGroup("jobTargetGroupResource", {
    jobAgentName: "string",
    members: [{
        type: "string",
        databaseName: "string",
        elasticPoolName: "string",
        membershipType: azure_native.sql.JobTargetGroupMembershipType.Include,
        refreshCredential: "string",
        serverName: "string",
        shardMapName: "string",
    }],
    resourceGroupName: "string",
    serverName: "string",
    targetGroupName: "string",
});
type: azure-native:sql:JobTargetGroup
properties:
    jobAgentName: string
    members:
        - databaseName: string
          elasticPoolName: string
          membershipType: Include
          refreshCredential: string
          serverName: string
          shardMapName: string
          type: string
    resourceGroupName: string
    serverName: string
    targetGroupName: string
JobTargetGroup Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The JobTargetGroup resource accepts the following input properties:
- JobAgent stringName 
- The name of the job agent.
- Members
List<Pulumi.Azure Native. Sql. Inputs. Job Target> 
- Members of the target group.
- ResourceGroup stringName 
- 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 stringName 
- The name of the target group.
- JobAgent stringName 
- The name of the job agent.
- Members
[]JobTarget Args 
- Members of the target group.
- ResourceGroup stringName 
- 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 stringName 
- The name of the target group.
- jobAgent StringName 
- The name of the job agent.
- members
List<JobTarget> 
- Members of the target group.
- resourceGroup StringName 
- 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 StringName 
- The name of the target group.
- jobAgent stringName 
- The name of the job agent.
- members
JobTarget[] 
- Members of the target group.
- resourceGroup stringName 
- 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 stringName 
- The name of the target group.
- job_agent_ strname 
- The name of the job agent.
- members
Sequence[JobTarget Args] 
- Members of the target group.
- resource_group_ strname 
- 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_ strname 
- The name of the target group.
- jobAgent StringName 
- The name of the job agent.
- members List<Property Map>
- Members of the target group.
- resourceGroup StringName 
- 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 StringName 
- The name of the target group.
Outputs
All input properties are implicitly available as output properties. Additionally, the JobTargetGroup resource produces the following output properties:
Supporting Types
JobTarget, JobTargetArgs    
- Type
string | Pulumi.Azure Native. Sql. Job Target Type 
- The target type.
- DatabaseName string
- The target database name.
- ElasticPool stringName 
- The target elastic pool name.
- MembershipType Pulumi.Azure Native. Sql. Job Target Group Membership Type 
- Whether the target is included or excluded from the group.
- RefreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- ServerName string
- The target server name.
- string
- The target shard map.
- Type
string | JobTarget Type 
- The target type.
- DatabaseName string
- The target database name.
- ElasticPool stringName 
- The target elastic pool name.
- MembershipType JobTarget Group Membership Type 
- Whether the target is included or excluded from the group.
- RefreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- ServerName string
- The target server name.
- string
- The target shard map.
- type
String | JobTarget Type 
- The target type.
- databaseName String
- The target database name.
- elasticPool StringName 
- The target elastic pool name.
- membershipType JobTarget Group Membership Type 
- Whether the target is included or excluded from the group.
- refreshCredential String
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName String
- The target server name.
- String
- The target shard map.
- type
string | JobTarget Type 
- The target type.
- databaseName string
- The target database name.
- elasticPool stringName 
- The target elastic pool name.
- membershipType JobTarget Group Membership Type 
- Whether the target is included or excluded from the group.
- refreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName string
- The target server name.
- string
- The target shard map.
- type
str | JobTarget Type 
- The target type.
- database_name str
- The target database name.
- elastic_pool_ strname 
- The target elastic pool name.
- membership_type JobTarget Group Membership Type 
- Whether the target is included or excluded from the group.
- refresh_credential str
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- server_name str
- The target server name.
- str
- The target shard map.
- type
String | "TargetGroup" | "Sql Database" | "Sql Elastic Pool" | "Sql Shard Map" | "Sql Server" 
- The target type.
- databaseName String
- The target database name.
- elasticPool StringName 
- The target elastic pool name.
- membershipType "Include" | "Exclude"
- Whether the target is included or excluded from the group.
- refreshCredential String
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName String
- The target server name.
- String
- The target shard map.
JobTargetGroupMembershipType, JobTargetGroupMembershipTypeArgs          
- Include
- Include
- Exclude
- Exclude
- JobTarget Group Membership Type Include 
- Include
- JobTarget Group Membership Type Exclude 
- Exclude
- Include
- Include
- Exclude
- Exclude
- Include
- Include
- Exclude
- Exclude
- INCLUDE
- Include
- EXCLUDE
- Exclude
- "Include"
- Include
- "Exclude"
- Exclude
JobTargetResponse, JobTargetResponseArgs      
- Type string
- The target type.
- DatabaseName string
- The target database name.
- ElasticPool stringName 
- The target elastic pool name.
- MembershipType string
- Whether the target is included or excluded from the group.
- RefreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- ServerName string
- The target server name.
- string
- The target shard map.
- Type string
- The target type.
- DatabaseName string
- The target database name.
- ElasticPool stringName 
- The target elastic pool name.
- MembershipType string
- Whether the target is included or excluded from the group.
- RefreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- ServerName string
- The target server name.
- string
- The target shard map.
- type String
- The target type.
- databaseName String
- The target database name.
- elasticPool StringName 
- The target elastic pool name.
- membershipType String
- Whether the target is included or excluded from the group.
- refreshCredential String
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName String
- The target server name.
- String
- The target shard map.
- type string
- The target type.
- databaseName string
- The target database name.
- elasticPool stringName 
- The target elastic pool name.
- membershipType string
- Whether the target is included or excluded from the group.
- refreshCredential string
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName string
- The target server name.
- string
- The target shard map.
- type str
- The target type.
- database_name str
- The target database name.
- elastic_pool_ strname 
- The target elastic pool name.
- membership_type str
- Whether the target is included or excluded from the group.
- refresh_credential str
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- server_name str
- The target server name.
- str
- The target shard map.
- type String
- The target type.
- databaseName String
- The target database name.
- elasticPool StringName 
- The target elastic pool name.
- membershipType String
- Whether the target is included or excluded from the group.
- refreshCredential String
- The resource ID of the credential that is used during job execution to connect to the target and determine the list of databases inside the target.
- serverName String
- The target server name.
- String
- The target shard map.
JobTargetType, JobTargetTypeArgs      
- TargetGroup 
- TargetGroup
- SqlDatabase 
- SqlDatabase
- SqlElastic Pool 
- SqlElasticPool
- SqlShard Map 
- SqlShardMap
- SqlServer 
- SqlServer
- JobTarget Type Target Group 
- TargetGroup
- JobTarget Type Sql Database 
- SqlDatabase
- JobTarget Type Sql Elastic Pool 
- SqlElasticPool
- JobTarget Type Sql Shard Map 
- SqlShardMap
- JobTarget Type Sql Server 
- SqlServer
- TargetGroup 
- TargetGroup
- SqlDatabase 
- SqlDatabase
- SqlElastic Pool 
- SqlElasticPool
- SqlShard Map 
- SqlShardMap
- SqlServer 
- SqlServer
- TargetGroup 
- TargetGroup
- SqlDatabase 
- SqlDatabase
- SqlElastic Pool 
- SqlElasticPool
- SqlShard Map 
- SqlShardMap
- SqlServer 
- SqlServer
- TARGET_GROUP
- TargetGroup
- SQL_DATABASE
- SqlDatabase
- SQL_ELASTIC_POOL
- SqlElasticPool
- SQL_SHARD_MAP
- SqlShardMap
- SQL_SERVER
- SqlServer
- "TargetGroup" 
- TargetGroup
- "SqlDatabase" 
- SqlDatabase
- "SqlElastic Pool" 
- SqlElasticPool
- "SqlShard Map" 
- SqlShardMap
- "SqlServer" 
- SqlServer
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:sql:JobTargetGroup targetGroup1 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/jobAgents/{jobAgentName}/targetGroups/{targetGroupName} 
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0