SQL-DMO
SQL Server Agent Type Constants (SQLDMO_JOBSERVER_TYPE)
Microsoft® SQL Server Agent service type constants expose an instance of Microsoft SQL Server™ participation in multiserver administration.
| Constant | Value | Description |
|---|---|---|
| SQLDMOJobServer_MSX | 3 | Participates in multiserver administration. An instance of SQL Server masters administration for other servers. |
| SQLDMOJobServer_StandAlone | 1 | Does not participate in multiserver administration. |
| SQLDMOJobServer_TSX | 2 | Participates in multiserver administration. An instance of SQL Server is a target for administration. |
| SQLDMOJobServer_Unknown | 0 | Bad or invalid value. |