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)