Type Property (Category) (SQL-DMO)

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

Applies To

Category Object

Syntax

object.Type [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying a job category classification as described in Settings

Settings
Constant Value Description
SQLDMOCategoryType_LocalJob 1 Category is used to classify jobs that will execute on the SQL Server installation on which the job is stored
SQLDMOCategoryType_
MultiServerJob
2 Category is used to classify jobs that will execute on one or more TSX target servers
SQLDMOCategoryType_None 3 Job is not classified by a category
SQLDMOCategoryType_Unknown 0 Category is bad or invalid, or the Category object references a classification used for alerts or operators

Remarks

The Type property is valid only for categories used to classify SQL Server Agent jobs.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetType(SQLDMO_CATEGORYTYPE_TYPE* pRetVal)

HRESULT SetType(SQLDMO_CATEGORYTYPE_TYPE NewValue)

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.