Operator 成員
The Operator class represents a SQL Server Agent operator.
Operator 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
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. |
頂端
方法
| 名稱 | 描述 | |
|---|---|---|
.gif "受保護的方法") |
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。) |
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
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. |
.gif "受保護的屬性") |
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. |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端