Classe OperatorCategory
The OperatorCategory class contains attributes that allow operators to be categorized.
Gerarchia di ereditarietà
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.Agent.AgentObjectBase
Microsoft.SqlServer.Management.Smo.Agent.CategoryBase
Microsoft.SqlServer.Management.Smo.Agent.OperatorCategory
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
Public NotInheritable Class OperatorCategory _
Inherits CategoryBase
'Utilizzo
Dim instance As OperatorCategory
public sealed class OperatorCategory : CategoryBase
public ref class OperatorCategory sealed : public CategoryBase
[<SealedAttribute>]
type OperatorCategory =
class
inherit CategoryBase
end
public final class OperatorCategory extends CategoryBase
Nel tipo OperatorCategory sono esposti i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
OperatorCategory() | Initializes a new instance of the OperatorCategory class. | |
OperatorCategory(JobServer, String) | Initializes a new instance of the OperatorCategory class on the specified instance of Microsoft SQL Server Agent and with the specified name. |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
ID | Gets the ID value that uniquely identifies the operator category. | |
Name | Gets or sets the name of the object. Ereditato da NamedSmoObject. | |
Parent | Gets the JobServer object that is the parent of the OperatorCategory object. | |
Properties | Gets a collection of Property objects that represent the object properties. Ereditato da SqlSmoObject. | |
State | Gets the state of the referenced object. Ereditato da SmoObjectBase. | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. Ereditato da SqlSmoObject. | |
UserData | Gets or sets user-defined data associated with the referenced object. Ereditato da SmoObjectBase. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
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. Ereditato da CategoryBase. | |
Discover | Discovers a list of type Object. Ereditato da SqlSmoObject. | |
Drop | Removes an existing job category, operator category, or alert category. Ereditato da CategoryBase. | |
Equals | Ereditato da Object. | |
FormatSqlVariant | Formats an object as SqlVariant type. Ereditato da SqlSmoObject. | |
GetContextDB | Gets the context database that is associated with this object. Ereditato da SqlSmoObject. | |
GetDBName | Gets the database name that is associated with the object. Ereditato da AgentObjectBase. | |
GetHashCode | Ereditato da Object. | |
GetPropValue | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetServerObject | Gets the server of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetType | Ereditato da Object. | |
Initialize() | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
IsObjectInitialized | Verifies whether the object has been initialized. Ereditato da SqlSmoObject. | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. Ereditato da SqlSmoObject. | |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. Ereditato da SqlSmoObject. | |
Rename | Renames the job category, the operator category, or the alert category. Ereditato da CategoryBase. | |
Script() | Generates a Transact-SQL script that can be used to re-create the job category, the operator category, or the alert category. Ereditato da CategoryBase. | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the job category, the operator category, or the alert category as specified by the scripting options. Ereditato da CategoryBase. | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. Ereditato da SqlSmoObject. | |
ToString | Returns a String that represents the referenced object. Ereditato da SqlSmoObject. | |
Validate | Validates the state of an object. Ereditato da SmoObjectBase. |
In alto
Eventi
Nome | Descrizione | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. Ereditato da SqlSmoObject. | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. Ereditato da SqlSmoObject. |
In alto
Implementazioni esplicite dell'interfaccia
Nome | Descrizione | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetDomainRoot | Returns the root of the domain. Ereditato da SqlSmoObject. | |
IAlienObject.GetParent | Gets the parent of this object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyType | Gets the type of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. Ereditato da SqlSmoObject. | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. Ereditato da SqlSmoObject. | |
IAlienObject.SetPropertyValue | Sets the property value. Ereditato da SqlSmoObject. | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. Ereditato da SqlSmoObject. |
In alto
Osservazioni
SQL Server Agent categories provide optional attributes that are used to distinguish groups of operators.
With the OperatorCategory object, you can:
- Create groupings for operators.
The category name must be unique.
To get OperatorCategory object properties, users must be a member of the SQLAgentUserRole database role on the MSDB database, or be a member of the sysadmin fixed server role.
To set OperatorCategory object properties, users must be a member of the sysadmin fixed server role.
To create or drop an operator category, users must be a member of the sysadmin fixed server role.
Thread Safety
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Esempi
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Altre risorse
Automatizzazione delle attività amministrative (SQL Server Agent)
Pianificazione delle attività amministrative automatiche in SQL Server Agent