The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ component.
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 |
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 |
The Type property is valid only for categories used to classify SQL Server Agent jobs.
Long, enumerated
Read/write
HRESULT GetType(SQLDMO_CATEGORYTYPE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_CATEGORYTYPE_TYPE NewValue)