AgentSubSystem Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
-
AgentSubSystem
- Attributes
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 |