SQL-DMO
Type Property (Category)
The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.
Applies To
Category Object |
Syntax
object.Type [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies a job category classification as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetType(SQLDMO_CATEGORYTYPE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_CATEGORYTYPE_TYPE NewValue)
Settings
Constant | Value | Description |
---|---|---|
SQLDMOCategoryType_LocalJob | 1 | Category is used to classify jobs that will execute on an instance of SQL Server on which the job is stored. |
SQLDMOCategoryType_MultiServerJob | 2 | Category is used to classify jobs that will execute on one or more 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.