JobCategory Methods
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
 |
Create |
Creates the job category, the operator category, or the alert category based on the JobCategory object, the OperatorCategory object, or the AlertCategory object respectively.
(inherited from CategoryBase ) |
|
Drop |
Removes an existing job category, operator category, or alert category.
(inherited from CategoryBase ) |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
Initialize | Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from SqlSmoObject ) |
 |
ReferenceEquals | (inherited from Object ) |
|
Refresh |
Refreshes the object and retrieves properties when the object is next accessed.
(inherited from SqlSmoObject ) |
|
Rename | (inherited from CategoryBase ) |
|
Script | Overloaded.
Generates a Transact-SQL script that can be used to re-create the job category, the operator category, or the alert category.
(inherited from CategoryBase ) |
|
ToString |
Returns a String that represents the referenced object.
(inherited from SqlSmoObject ) |
Protected Methods
| Name | Description | |
|---|---|---|
 |
AlterImpl | (inherited from SqlSmoObject ) |
|
AlterImplFinish | (inherited from SqlSmoObject ) |
|
AlterImplInit | (inherited from SqlSmoObject ) |
|
AlterImplWorker | (inherited from SqlSmoObject ) |
|
BindDefaultImpl | (inherited from SqlSmoObject ) |
|
BindRuleImpl | (inherited from SqlSmoObject ) |
|
CheckCollation | (inherited from SqlSmoObject ) |
|
CheckObjectState | Overloaded.
Validates the state of the referenced object.
(inherited from SqlSmoObject ) |
|
CheckObjectStateImpl | (inherited from SqlSmoObject ) |
|
CheckVersion80 |
Checks the validity of the object on Microsoft SQL Server 2000.
(inherited from SqlSmoObject ) |
|
CheckVersion80SP3 |
Checks the validity of the object on Microsoft SQL Server 2000 SP3.
(inherited from SqlSmoObject ) |
|
CheckVersion90 |
Check the validity of the object on Microsoft SQL Server 2005.
(inherited from SqlSmoObject ) |
|
CheckVersionBelow90 | (inherited from SqlSmoObject ) |
|
CleanObject | (inherited from SqlSmoObject ) |
|
CreateImpl | (inherited from SqlSmoObject ) |
|
CreateImplFinish | (inherited from SqlSmoObject ) |
|
CreateImplInit | (inherited from SqlSmoObject ) |
|
DropImpl | (inherited from SqlSmoObject ) |
|
DropImplWorker | (inherited from SqlSmoObject ) |
|
Finalize | (inherited from Object ) |
|
FormatSqlVariant | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceScript | (inherited from SqlSmoObject ) |
|
GetBindDefaultScript | (inherited from SqlSmoObject ) |
|
GetBindRuleScript | (inherited from SqlSmoObject ) |
|
GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetCatTypeName | (inherited from CategoryBase ) |
|
GetDateTimeParameter | (inherited from SqlSmoObject ) |
|
GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) |
|
GetDBName |
Gets the database name that is associated with the object.
(inherited from AgentObjectBase ) |
|
GetEnumParameter | (inherited from SqlSmoObject ) |
|
GetFragOptionString | (inherited from SqlSmoObject ) |
|
GetGuidParameter | (inherited from SqlSmoObject ) |
|
GetParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetPropValue | (inherited from SqlSmoObject ) |
|
GetPropValueOptional | (inherited from SqlSmoObject ) |
|
GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) |
|
GetRealValue | (inherited from SqlSmoObject ) |
|
GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) |
|
GetServerName |
Gets the name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject ) |
|
GetSqlServerVersionName |
Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject ) |
|
GetStringParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) |
|
GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) |
|
ImplInitialize | (inherited from SqlSmoObject ) |
|
IsCollectionDirty | (inherited from SqlSmoObject ) |
|
IsObjectDirty |
Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of Microsoft SQL Server.
(inherited from SqlSmoObject ) |
|
IsObjectInitialized |
Verifies whether the object has been initialized.
(inherited from SqlSmoObject ) |
|
IsObjectInSpace |
Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
(inherited from SqlSmoObject ) |
|
IsVersion80SP3 | (inherited from SqlSmoObject ) |
|
MarkDropped | (inherited from SqlSmoObject ) |
|
MarkForDropImpl | (inherited from SqlSmoObject ) |
|
MemberwiseClone | (inherited from Object ) |
|
PostAlter | (inherited from SqlSmoObject ) |
|
PostCreate | (inherited from SqlSmoObject ) |
|
PostDrop | (inherited from SqlSmoObject ) |
|
RenameImpl | (inherited from NamedSmoObject ) |
|
RenameImplWorker | (inherited from NamedSmoObject ) |
|
ScriptAlter | (inherited from SqlSmoObject ) |
|
ScriptChangeOwner | (inherited from NamedSmoObject ) |
|
ScriptCreate | (inherited from CategoryBase ) |
|
ScriptDdl | (inherited from SqlSmoObject ) |
|
ScriptDrop | (inherited from CategoryBase ) |
|
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) |
|
ScriptImplWorker | (inherited from SqlSmoObject ) |
|
ScriptRename | (inherited from CategoryBase ) |
|
SetParentImpl | (inherited from SqlSmoObject ) |
|
Trace | (inherited from SqlSmoObject ) |
|
UnbindDefaultImpl | (inherited from SqlSmoObject ) |
|
UnbindRuleImpl | (inherited from SqlSmoObject ) |
|
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
See Also
Reference
JobCategory Class
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Scheduling Automatic Administrative Tasks in SQL Server Agent
Automating Administrative Tasks (SQL Server Agent)
sp_add_category (Transact-SQL)