SQL Server Agent Type Constants (SQLDMO_JOBSERVER_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
SQL Server Agent 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 |
The value is not valid. |