This topic has not yet been rated - Rate this topic

Type Property (JobServer)

SQL Server 2005

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.

The Type property exposes configured attributes of the referenced Microsoft SQL Server component.

Syntax


object
.Type

Parts

object: An expression that evaluates to an object in the Applies To list

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetType(SQLDMO_JOBSERVER_TYPE* pRetVal)

Returns

For the JobServer object, interpret the Type property using these values.

Constant	Value	Description
SQLDMOJobServer_MSX	3	An instance of SQL Server participates in multiserver administration. The current instance of SQL Server masters administration for other servers.
SQLDMOJobServer_StandAlone	1	The current instance of SQL Server does not participate in multiserver administration.
SQLDMOJobServer_TSX	2	The current instance of SQL Server participates in multiserver administration. The current instance of SQL Server is a target for administration.
SQLDMOJobServer_Unknown	0	The value is not valid.

Remarks

Create master servers using SQL-DMO by adding a SQL Server Agent master server operator to those instances of SQL Server that will master a multiserver administration group. Use the MSXEnlist and MSXDefect methods of the JobServer object referencing a target server to manage group membership.

Note:
For this property to work correctly the SQL Server Agent extended stored procedures must have been enabled using sp_configure.

Applies To:

JobServer Object

Reference

MSXDefect Method
MSXEnlist Method

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD