Condividi tramite

AgentSubSystem Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo.Agent
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Since proxy accounts are tightly coupled with SQL Agent subsystems and we don't have a special SubSystem object, but rather an enum. The values of this enum must match the service_id value from the engine

[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.AgentSubSystemTypeConverter))]
public enum AgentSubSystem
[<System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.AgentSubSystemTypeConverter))>]
type AgentSubSystem = 
Public Enum AgentSubSystem
Inheritance
Enum
AgentSubSystem
Attributes
TypeConverterAttribute

Fields

Name Value Description
TransactSql 1

Starting from 1 since that's how sp_enum_sqlagent_subsystems returns it Transact-SQL script (T-SQL)
ActiveScripting 2

ActiveX Scripting
CmdExec 3

Operating system (CmdExec)
Snapshot 4

Replication snapshot
LogReader 5

Replication Transaction-Log reader
Distribution 6

Replication Distributor
Merge 7

Replication Merge
QueueReader 8

Replication Queue Reader
AnalysisQuery 9

SQL Server Analysis Services query
AnalysisCommand 10

SQL Servier Analysis Services Command
Ssis 11

SQL Server Integration Services package
PowerShell 12

PowerShell subsystem

Applies to