Operator 类

The Operator class represents a SQL Server Agent operator.

继承层次结构

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..::..Operator

命名空间：  Microsoft.SqlServer.Management.Smo.Agent
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public NotInheritable Class Operator _
    Inherits AgentObjectBase _
    Implements ICreatable, IDroppable, IAlterable, IRenamable,  _
    IScriptable
用法
Dim instance As [Operator]

public sealed class Operator : AgentObjectBase, 
    ICreatable, IDroppable, IAlterable, IRenamable, IScriptable

public ref class Operator sealed : public AgentObjectBase, 
    ICreatable, IDroppable, IAlterable, IRenamable, IScriptable

[<SealedAttribute>]
type Operator =  
    class
        inherit AgentObjectBase
        interface ICreatable
        interface IDroppable
        interface IAlterable
        interface IRenamable
        interface IScriptable
    end

public final class Operator extends AgentObjectBase implements ICreatable, IDroppable, IAlterable, IRenamable, IScriptable

Operator 类型公开以下成员。

构造函数

	名称	说明
	Operator() () () ()	Initializes a new instance of the Operator class.
	Operator(JobServer, String)	Initializes a new instance of the Operator class on the specified SQL Server Agent and with the specified name.

页首

属性

	名称	说明
	CategoryName	Gets or sets the name of the category to which the operator belongs.
	EmailAddress	Gets or sets the e-mail address of the referenced operator.
	Enabled	Gets or sets the Boolean property value that specifies whether the operator is enabled or not.
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. （从 SqlSmoObject 继承。）
	ID	Gets the ID value that uniquely identifies the operator.
	IsTouched	Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. （从 SqlSmoObject 继承。）
	LastEmailDate	Gets the date and time when the operator last received an alert notification by e-mail.
	LastNetSendDate	Gets the date and time when the operator last received an alert notification by net-send.
	LastPagerDate	Gets the date and time when the operator last received an alert notification by pager.
	Name	Gets or sets the name of the object. （从 NamedSmoObject 继承。）
	NetSendAddress	Gets or sets an operator's net-send address.
	ObjectInSpace	Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. （从 SqlSmoObject 继承。）
	PagerAddress	Gets or sets an operator's pager address.
	PagerDays	Gets or sets the days of the week on which SQL Server Agent attempts to notify the referenced operator by pager.
	Parent	Gets or sets the JobServer object that is the parent of the Operator object.
	Properties	Gets a collection of Property objects that represent the object properties. （从 SqlSmoObject 继承。）
	SaturdayPagerEndTime	Gets or sets the latest time of day at which the referenced operator is available to receive alert notification by pager on Saturdays.
	SaturdayPagerStartTime	Gets or sets the earliest time of day at which the referenced operator is available to receive alert notification by pager on Saturdays.
	ScalarResult	Gets the scalar result for the referenced object. （从 SqlSmoObject 继承。）
	State	Gets the state of the referenced object. （从 SmoObjectBase 继承。）
	SundayPagerEndTime	Gets or sets the latest time of day at which the referenced operator is available to receive alert notification by pager on Sundays.
	SundayPagerStartTime	Gets or sets the earliest time of day at which the referenced operator is available to receive alert notification by pager on Sundays.
	Urn	Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. （从 SqlSmoObject 继承。）
	UserData	Gets or sets user-defined data associated with the referenced object. （从 SmoObjectBase 继承。）
	WeekdayPagerEndTime	Gets or sets the latest time of day at which the referenced operator is available to receive alert notification by pager on weekdays.
	WeekdayPagerStartTime	Gets or sets the earliest time of day at which the referenced operator is available to receive alert notification by pager on weekdays.

页首

方法

	名称	说明
	AddDatabaseContext	（从 SqlSmoObject 继承。）
	AddNotification	Assigns the referenced operator to an alert so that the operator is sent a notification when the specified alert is raised.
	Alter	Updates any Operator object property changes on the instance of Microsoft SQL Server.
	AlterImpl	（从 SqlSmoObject 继承。）
	AlterImplFinish	（从 SqlSmoObject 继承。）
	AlterImplInit	（从 SqlSmoObject 继承。）
	AlterImplWorker	（从 SqlSmoObject 继承。）
	BindDefaultImpl	（从 SqlSmoObject 继承。）
	BindRuleImpl	（从 SqlSmoObject 继承。）
	CheckCollation	（从 SqlSmoObject 继承。）
	CheckObjectState() () () ()	Validates the state of the referenced object. （从 SqlSmoObject 继承。）
	CheckObjectState(Boolean)	Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. （从 SqlSmoObject 继承。）
	CheckObjectStateImpl	（从 SqlSmoObject 继承。）
	CheckVersion100	（从 SqlSmoObject 继承。）
	CheckVersion80	Checks the validity of the object on SQL Server 2000. （从 SqlSmoObject 继承。）
	CheckVersion80SP3	Checks the validity of the object on SQL Server 2000 SP3. （从 SqlSmoObject 继承。）
	CheckVersion90	Check the validity of the object on SQL Server 2005. （从 SqlSmoObject 继承。）
	CheckVersionBelow90	（从 SqlSmoObject 继承。）
	CleanObject	（从 SqlSmoObject 继承。）
	Create	Creates an operator on the instance of Microsoft SQL Server as defined by the Operator object.
	CreateImpl	（从 SqlSmoObject 继承。）
	CreateImplFinish	（从 SqlSmoObject 继承。）
	CreateImplInit	（从 SqlSmoObject 继承。）
	Discover	（从 SqlSmoObject 继承。）
	Drop	Removes the referenced operator.
	DropImpl	（从 SqlSmoObject 继承。）
	DropImplWorker	（从 SqlSmoObject 继承。）
	EnumJobNotifications	Enumerates a list of notifications made by SQL Server Agent on completion of a job execution.
	EnumNotifications() () () ()	Enumerates a list of notifications made by SQL Server Agent for job completion and for raised alerts.
	EnumNotifications(String)	Enumerates a list of notifications made by SQL Server Agent for the specified alert.
	EnumNotifications(NotifyMethods)
	EnumNotifications(NotifyMethods, String)
	EnumScriptImpl	（从 SqlSmoObject 继承。）
	EnumScriptImplWorker	（从 SqlSmoObject 继承。）
	Equals	（从 Object 继承。）
	Finalize	（从 Object 继承。）
	FormatSqlVariant	（从 SqlSmoObject 继承。）
	GenerateDataSpaceFileStreamScript	（从 SqlSmoObject 继承。）
	GenerateDataSpaceScript	（从 SqlSmoObject 继承。）
	GetBindDefaultScript	（从 SqlSmoObject 继承。）
	GetBindRuleScript	（从 SqlSmoObject 继承。）
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	（从 SqlSmoObject 继承。）
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	（从 SqlSmoObject 继承。）
	GetDateTimeParameter	（从 SqlSmoObject 继承。）
	GetDateTimeParameterAsInt	（从 SqlSmoObject 继承。）
	GetDBName	Gets the database name that is associated with the object. （从 AgentObjectBase 继承。）
	GetEnumParameter	（从 SqlSmoObject 继承。）
	GetFragOptionString	（从 SqlSmoObject 继承。）
	GetGuidParameter	（从 SqlSmoObject 继承。）
	GetHashCode	（从 Object 继承。）
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	（从 SqlSmoObject 继承。）
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	（从 SqlSmoObject 继承。）
	GetPropValue	（从 SqlSmoObject 继承。）
	GetPropValueOptional	（从 SqlSmoObject 继承。）
	GetPropValueOptionalAllowNull	（从 SqlSmoObject 继承。）
	GetRealValue	（从 SqlSmoObject 继承。）
	GetScriptingOptionsForCreate	（从 SqlSmoObject 继承。）
	GetServerName	Gets the name of the instance of SQL Server with which the object is associated. （从 SqlSmoObject 继承。）
	GetServerObject	（从 SqlSmoObject 继承。）
	GetSqlServerVersionName	Gets the version name of the instance of SQL Server with which the object is associated. （从 SqlSmoObject 继承。）
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	（从 SqlSmoObject 继承。）
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	（从 SqlSmoObject 继承。）
	GetTimeSpanParameterAsInt	（从 SqlSmoObject 继承。）
	GetType	（从 Object 继承。）
	GetUrnRecursive(StringBuilder)	（从 SqlSmoObject 继承。）
	GetUrnRecursive(StringBuilder, UrnIdOption)	（从 SqlSmoObject 继承。）
	ImplInitialize	（从 SqlSmoObject 继承。）
	Initialize() () () ()	Initializes the object and forces the properties be loaded. （从 SqlSmoObject 继承。）
	Initialize(Boolean)	Initializes the object and forces the properties be loaded. （从 SqlSmoObject 继承。）
	IsObjectDirty	Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. （从 SqlSmoObject 继承。）
	IsObjectInitialized	Verifies whether the object has been initialized. （从 SqlSmoObject 继承。）
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of SQL Server. （从 SqlSmoObject 继承。）
	IsVersion80SP3	（从 SqlSmoObject 继承。）
	MarkDropped	（从 SqlSmoObject 继承。）
	MarkForDropImpl	（从 SqlSmoObject 继承。）
	MemberwiseClone	（从 Object 继承。）
	PostAlter	（从 SqlSmoObject 继承。）
	PostCreate	（从 SqlSmoObject 继承。）
	PostDrop	（从 SqlSmoObject 继承。）
	Refresh	Refreshes the object and retrieves properties when the object is next accessed. （从 SqlSmoObject 继承。）
	RemoveNotification	Removes the association between the referenced operator and a specified alert.
	Rename	Renames the referenced operator.
	RenameImpl	This method supports the SMO infrastructure and is not intended to be used directly from your code. （从 NamedSmoObject 继承。）
	RenameImplWorker	This method supports the SMO infrastructure and is not intended to be used directly from your code. （从 NamedSmoObject 继承。）
	Script() () () ()	Generates a Transact-SQL script that can be used to re-create the SQL Server Agent operator.
	Script(ScriptingOptions)	Generates a Transact-SQL script that can be used to re-create the SQL Server Agent operator as specified by the scripting options.
	ScriptAlter	（从 SqlSmoObject 继承。）
	ScriptChangeOwner	This method supports the SMO infrastructure and is not intended to be used directly from your code. （从 NamedSmoObject 继承。）
	ScriptCreate	（从 SqlSmoObject 继承。）
	ScriptDdl	（从 SqlSmoObject 继承。）
	ScriptDrop	（从 SqlSmoObject 继承。）
	ScriptImpl() () () ()	（从 SqlSmoObject 继承。）
	ScriptImpl(ScriptingOptions)	（从 SqlSmoObject 继承。）
	ScriptImplWorker	（从 SqlSmoObject 继承。）
	ScriptRename	This method supports the SMO infrastructure and is not intended to be used directly from your code. （从 NamedSmoObject 继承。）
	SetParentImpl	（从 SqlSmoObject 继承。）
	ToString	Returns a String that represents the referenced object. （从 SqlSmoObject 继承。）
	TouchImpl	（从 SqlSmoObject 继承。）
	UnbindDefaultImpl	（从 SqlSmoObject 继承。）
	UnbindRuleImpl	（从 SqlSmoObject 继承。）
	UpdateNotification	Alters the notification method without dropping the association between an alert and an operator.
	Validate	（从 SmoObjectBase 继承。）

页首

事件

	名称	说明
	PropertyChanged	（从 SqlSmoObject 继承。）
	PropertyMetadataChanged	（从 SqlSmoObject 继承。）

页首

字段

	名称	说明
	m_ExtendedProperties	（从 SqlSmoObject 继承。）

页首

显式接口实现

	名称	说明
	IAlienObjectDiscover	（从 SqlSmoObject 继承。）
	IAlienObjectGetParent	（从 SqlSmoObject 继承。）
	IAlienObjectGetProperty	（从 SqlSmoObject 继承。）
	ISfcPropertyProviderGetPropertySet	（从 SqlSmoObject 继承。）
	IAlienObjectGetUrn	（从 SqlSmoObject 继承。）
	IAlienObjectResolve	（从 SqlSmoObject 继承。）
	IAlienObjectSetProperty	（从 SqlSmoObject 继承。）

页首

注释

To get Operator 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 Operator object properties, users must be a member of the sysadmin fixed server role.

To create or delete an operator, users must be a member of the sysadmin fixed server role.

To update notification for an operator, users must be a member of the sysadmin fixed server role.

Thread Safety

此类型的任何公共静态（Microsoft Visual Basic 中的 Shared）成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。

示例

在 SQL Server 代理中计划自动管理任务

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo.Agent 命名空间

其他资源

在 SQL Server 代理中计划自动管理任务

自动执行管理任务（SQL Server 代理）

sp_add_operator (Transact-SQL)