ScheduleBase-Klasse
The ScheduleBase class is a base class that is inherited by the JobSchedule class.
Vererbungshierarchie
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.ScheduleBase
Microsoft.SqlServer.Management.Smo.Agent.JobSchedule
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Class ScheduleBase _
Inherits AgentObjectBase
'Usage
Dim instance As ScheduleBase
public class ScheduleBase : AgentObjectBase
public ref class ScheduleBase : public AgentObjectBase
type ScheduleBase =
class
inherit AgentObjectBase
end
public class ScheduleBase extends AgentObjectBase
Der ScheduleBase-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Methode") |
ScheduleBase | Initializes a new instance of the ScheduleBase class. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Eigenschaft") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Eigenschaft") |
ID | Gets the ID value that uniquely identifies the schedule. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Geerbt von SqlSmoObject.) |
|
Name | Gets or sets the name of the object. (Geerbt von NamedSmoObject.) |
|
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. (Geerbt von SqlSmoObject.) |
|
Properties | Gets a collection of Property objects that represent the object properties. (Geerbt von SqlSmoObject.) |
|
ScalarResult | Gets the scalar result for the referenced object. (Geerbt von SqlSmoObject.) |
|
State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
|
AddDatabaseContext | Add the database context to the collection of queries identified by the queries parameter. (Geerbt von SqlSmoObject.) |
|
AlterImpl | Activates the object altered event. (Geerbt von SqlSmoObject.) |
|
AlterImplWorker | Calls the Alter methods. (Geerbt von SqlSmoObject.) |
|
BindDefaultImpl | Binds the default items identified by the parameters. (Geerbt von SqlSmoObject.) |
|
BindRuleImpl | Binds the rule schema to the rule and columns identified by the parameters. (Geerbt von SqlSmoObject.) |
|
CheckObjectState() | Validates the state of the referenced object. (Geerbt von 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. (Geerbt von SqlSmoObject.) |
|
CheckObjectStateImpl | Checks the state of a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
CheckVersion100 | Checks whether version of SQL Server is SQL Server 2008. (Geerbt von SqlSmoObject.) |
|
CheckVersion110() | Checks whether version of SQL Server is SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersion110(String) | Checks whether the version of SQL Server is SQL Server 2012 with the specified name. (Geerbt von SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Geerbt von SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Geerbt von SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow110 | Checks whether version of SQL Server is before SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow90 | Checks whether version of SQL Server is before SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CleanObject | Sets the object to its unmodified state. (Geerbt von SqlSmoObject.) |
|
CreateImpl | Creates an object with scripting options. (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Methode") |
Discover | Discovers a list of type Object. (Geerbt von SqlSmoObject.) |
|
DropImpl | Drops a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
DropImplWorker | Calls the drop methods. (Geerbt von SqlSmoObject.) |
|
Equals | (Geerbt von Object.) |
|
ExecuteNonQuery | Executes a batch of statements that does not return a result set. (Geerbt von SqlSmoObject.) |
|
ExecuteRenameQuery | Executes the rename query for the object. (Geerbt von NamedSmoObject.) |
|
Finalize | (Geerbt von Object.) |
|
FormatSqlVariant | Formats an object as SqlVariant type. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent() | Generates the alter event with the specified value. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent(Urn, Object) | Generates alter event with the specified URN and inner object value. (Geerbt von SqlSmoObject.) |
|
GetContextDB | Gets the context database that is associated with this object. (Geerbt von SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Geerbt von AgentObjectBase.) |
|
GetFragOptionString | Gets a FragmentationOption object as a string value. (Geerbt von SqlSmoObject.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetPropValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetRealValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetServerObject | Gets the server of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetType | (Geerbt von Object.) |
|
GetUrnRecursive(StringBuilder) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
ImplInitialize | Initializes the fields of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
Initialize() | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsVersion80SP3 | Determines whether the version of SQL Server is SQL Server 2000 with SP3. (Geerbt von SqlSmoObject.) |
|
IsVersion90AndAbove | Determines whether the version of SQL Server is SQL Server 2005 or later. (Geerbt von SqlSmoObject.) |
|
MarkDropped | Sets the SqlSmoState to dropped. (Geerbt von SqlSmoObject.) |
|
MarkForDropImpl | Sets the SqlSmoState for drop operation. (Geerbt von SqlSmoObject.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
PostAlter | The method that is activated after the SqlSmoObject is altered. (Geerbt von SqlSmoObject.) |
|
PostCreate | The method that is activated after the SqlSmoObject is created. (Geerbt von SqlSmoObject.) |
|
PostDrop | The method that is activated after the SqlSmoObject is dropped. (Geerbt von SqlSmoObject.) |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (Geerbt von SqlSmoObject.) |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Geerbt von NamedSmoObject.) |
|
RenameImplWorker | Nur für Informationszwecke identifiziert. Nicht unterstützt. Zukünftige Kompatibilität wird nicht sichergestellt. (Geerbt von NamedSmoObject.) |
|
ScriptImpl() | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
SetId | Sets the ID value that uniquely identifies the schedule. |
|
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Geerbt von SqlSmoObject.) |
|
SetSchemaOwned | Sets the schema owned value. (Geerbt von NamedSmoObject.) |
|
ToString | Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.) |
|
TouchImpl | Not implemented. (Geerbt von SqlSmoObject.) |
|
UnbindDefaultImpl | Unbinds the default columns of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
UnbindRuleImpl | Unbinds rules of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
Validate | Validates the state of an object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
PropertyChanged | Represents the event that occurs when a property is changed. (Geerbt von SqlSmoObject.) |
|
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Geerbt von SqlSmoObject.) |
Zum Anfang
Felder
| Name | Beschreibung | |
|---|---|---|
.gif "Geschütztes Feld") |
m_ExtendedProperties | Represents a property that is defined to extend the properties provided by a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
singletonParent | Represents the singleton parent. (Geerbt von SqlSmoObject.) |
Zum Anfang
Explizite Schnittstellenimplementierungen
| Name | Beschreibung | |
|---|---|---|
.gif "Explizite Schnittstellenimplementierung") .gif "Private Methode") |
IAlienObject.Discover | Discovers any dependencies. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetDomainRoot | Returns the root of the domain. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetParent | Gets the parent of this object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyType | Gets the type of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyValue | Gets the value of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetPropertyValue | Sets the property value. (Geerbt von SqlSmoObject.) |
|
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Geerbt von SqlSmoObject.) |
Zum Anfang
Hinweise
Thread Safety
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.
Beispiele
Planen von automatischen, administrativen Tasks im SQL Server-Agent
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo.Agent-Namespace