Membres JobSchedule
The JobSchedule class represents a SQL Server Agent job schedule.
Le type JobSchedule expose les membres suivants.
Constructeurs
| Nom | Description | |
|---|---|---|
.gif "Méthode publique") |
JobSchedule() () () () | Initializes a new instance of the JobSchedule class. |
|
JobSchedule(SqlSmoObject, String) | Initializes a new instance of the JobSchedule class for the specified parent object and that has the specified name. |
Haut de la page
Méthodes
| Nom | Description | |
|---|---|---|
.gif "Méthode protégée") |
AddDatabaseContext | (Hérité de SqlSmoObject.) |
|
Alter | Updates any JobSchedule object property changes on an instance of Microsoft SQL Server. |
|
AlterImpl | (Hérité de SqlSmoObject.) |
|
AlterImplFinish | (Hérité de SqlSmoObject.) |
|
AlterImplInit | (Hérité de SqlSmoObject.) |
|
AlterImplWorker | (Hérité de SqlSmoObject.) |
|
BindDefaultImpl | (Hérité de SqlSmoObject.) |
|
BindRuleImpl | (Hérité de SqlSmoObject.) |
|
CheckCollation | (Hérité de SqlSmoObject.) |
|
CheckObjectState() () () () | Validates the state of the referenced object. (Hérité de 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. (Hérité de SqlSmoObject.) |
|
CheckObjectStateImpl | (Hérité de SqlSmoObject.) |
|
CheckVersion100 | (Hérité de SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Hérité de SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Hérité de SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Hérité de SqlSmoObject.) |
|
CheckVersionBelow90 | (Hérité de SqlSmoObject.) |
|
CleanObject | (Hérité de SqlSmoObject.) |
|
Create | Creates a job schedule on the instance of SQL Server as defined by the JobSchedule object. |
|
CreateImpl | (Hérité de SqlSmoObject.) |
|
CreateImplFinish | (Hérité de SqlSmoObject.) |
|
CreateImplInit | (Hérité de SqlSmoObject.) |
|
Discover | (Hérité de SqlSmoObject.) |
|
Drop() () () () | Removes the referenced job schedule. |
|
Drop(Boolean) | |
|
DropImpl | (Hérité de SqlSmoObject.) |
|
DropImplWorker | (Hérité de SqlSmoObject.) |
|
EnumJobReferences | Returns an enumerated list of jobs that reference the schedule. |
|
EnumScriptImpl | (Hérité de SqlSmoObject.) |
|
EnumScriptImplWorker | (Hérité de SqlSmoObject.) |
|
Equals | (Hérité de Object.) |
|
Finalize | (Hérité de Object.) |
|
FormatSqlVariant | (Hérité de SqlSmoObject.) |
|
GenerateDataSpaceFileStreamScript | (Hérité de SqlSmoObject.) |
|
GenerateDataSpaceScript | (Hérité de SqlSmoObject.) |
|
GetBindDefaultScript | (Hérité de SqlSmoObject.) |
|
GetBindRuleScript | (Hérité de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetDateTimeParameter | (Hérité de SqlSmoObject.) |
|
GetDateTimeParameterAsInt | (Hérité de SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Hérité de AgentObjectBase.) |
|
GetEnumParameter | (Hérité de SqlSmoObject.) |
|
GetFragOptionString | (Hérité de SqlSmoObject.) |
|
GetGuidParameter | (Hérité de SqlSmoObject.) |
|
GetHashCode | (Hérité de Object.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetPropValue | (Hérité de SqlSmoObject.) |
|
GetPropValueOptional | (Hérité de SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | (Hérité de SqlSmoObject.) |
|
GetRealValue | (Hérité de SqlSmoObject.) |
|
GetScriptingOptionsForCreate | (Hérité de SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) |
|
GetServerObject | (Hérité de SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetTimeSpanParameterAsInt | (Hérité de SqlSmoObject.) |
|
GetType | (Hérité de Object.) |
|
GetUrnRecursive(StringBuilder) | (Hérité de SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (Hérité de SqlSmoObject.) |
|
ImplInitialize | (Hérité de SqlSmoObject.) |
|
Initialize() () () () | Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Hérité de SqlSmoObject.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Hérité de SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Hérité de SqlSmoObject.) |
|
IsVersion80SP3 | (Hérité de SqlSmoObject.) |
|
MarkDropped | (Hérité de SqlSmoObject.) |
|
MarkForDropImpl | (Hérité de SqlSmoObject.) |
|
MemberwiseClone | (Hérité de Object.) |
|
PostAlter | (Hérité de SqlSmoObject.) |
|
PostCreate | (Hérité de SqlSmoObject.) |
|
PostDrop | (Hérité de SqlSmoObject.) |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (Hérité de SqlSmoObject.) |
|
Rename | Renames the job schedule. |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
Script() () () () | Generates a Transact-SQL script that can be used to re-create the SQL Server Agent job schedule. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the SQL Server Agent job schedule as specified by the scripting options. |
|
ScriptAlter | (Hérité de SqlSmoObject.) |
|
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
ScriptCreate | (Hérité de SqlSmoObject.) |
|
ScriptDdl | (Hérité de SqlSmoObject.) |
|
ScriptDrop | (Hérité de SqlSmoObject.) |
|
ScriptImpl() () () () | (Hérité de SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | (Hérité de SqlSmoObject.) |
|
ScriptImplWorker | (Hérité de SqlSmoObject.) |
|
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
SetId | (Hérité de ScheduleBase.) |
|
SetParentImpl | (Hérité de SqlSmoObject.) |
|
ToString | Returns a String that represents the referenced object. (Hérité de SqlSmoObject.) |
|
TouchImpl | (Hérité de SqlSmoObject.) |
|
UnbindDefaultImpl | (Hérité de SqlSmoObject.) |
|
UnbindRuleImpl | (Hérité de SqlSmoObject.) |
|
Validate | (Hérité de SmoObjectBase.) |
Haut de la page
.gif "Champ protégé")
Propriétés
| Nom | Description | |
|---|---|---|
.gif "Propriété publique") |
ActiveEndDate | Gets or sets the date and time when the schedule ends. |
|
ActiveEndTimeOfDay | Gets or sets the time when the job schedule stops for the day. |
|
ActiveStartDate | Gets or sets the date and time when the schedule starts. |
|
ActiveStartTimeOfDay | Gets or sets the time when the job schedule starts for the day. |
|
DateCreated | Gets the date and time when the job schedule was created. |
.gif "Propriété protégée") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Hérité de SqlSmoObject.) |
|
FrequencyInterval | Gets or sets the frequency interval, which determines how often the job is scheduled to run. |
|
FrequencyRecurrenceFactor | Gets or sets the number of weeks or months between scheduled jobs for schedules with a weekly or monthly frequency type, respectively. |
|
FrequencyRelativeIntervals | Gets or sets the ordinal value of a day relative to the first day of the month, such as first, second, or last. |
|
FrequencySubDayInterval | Gets or sets the interval between scheduled jobs that run during the day. |
|
FrequencySubDayTypes | Gets or sets the unit of time used to specify the interval between scheduled jobs that run during the day. |
|
FrequencyTypes | Gets or sets the way in which frequency is evaluated for the job schedule, whether it's one time only, or weekly, or when the processor is idle, for example. |
|
ID | Gets the ID value that uniquely identifies the schedule. (Hérité de ScheduleBase.) |
|
IsEnabled | Gets or sets the Boolean property value that specifies whether the job schedule is enabled or disabled. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Hérité de SqlSmoObject.) |
|
JobCount | Gets the number of jobs that require the referenced job schedule. |
|
Name | Gets or sets the name of the object. (Hérité de 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. (Hérité de SqlSmoObject.) |
|
Parent | Gets or sets the Job object that is the parent of the JobSchedule object. |
|
Properties | Gets a collection of Property objects that represent the object properties. (Hérité de SqlSmoObject.) |
|
ScalarResult | Gets the scalar result for the referenced object. (Hérité de SqlSmoObject.) |
|
ScheduleUid | |
|
State | Gets the state of the referenced object. (Hérité de SmoObjectBase.) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Hérité de SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Hérité de SmoObjectBase.) |
Haut de la page
Événements
| Nom | Description | |
|---|---|---|
.gif "Événement public") |
PropertyChanged | (Hérité de SqlSmoObject.) |
|
PropertyMetadataChanged | (Hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
| Nom | Description | |
|---|---|---|
.gif "Implémentation d'interface explicite") .gif "Méthode privée") |
IAlienObjectDiscover | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetParent | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetProperty | (Hérité de SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetUrn | (Hérité de SqlSmoObject.) |
|
IAlienObjectResolve | (Hérité de SqlSmoObject.) |
|
IAlienObjectSetProperty | (Hérité de SqlSmoObject.) |
Haut de la page