Job Target Group Args
A group of job targets. Uses Azure REST API version 2023-08-01. In version 2.x of the Azure Native provider, it used API version 2021-11-01. Other available API versions: 2017-03-01-preview, 2020-02-02-preview, 2020-08-01-preview, 2020-11-01-preview, 2021-02-01-preview, 2021-05-01-preview, 2021-08-01-preview, 2021-11-01, 2021-11-01-preview, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]
. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.
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());
}
}
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
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}
Properties
The name of the job agent.
Members of the target group.
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
The name of the server.
The name of the target group.