JobSchedule 成員
The JobSchedule class represents a SQL Server Agent job schedule.
JobSchedule 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
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. |
頂端
方法
.gif "受保護的方法")
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
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 "受保護的屬性") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 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. (繼承自 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. (繼承自 SqlSmoObject。) |
|
JobCount | Gets the number of jobs that require the referenced job schedule. |
|
Name | Gets or sets the name of the object. (繼承自 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. (繼承自 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. (繼承自 SqlSmoObject。) |
|
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
|
ScheduleUid | |
|
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
|
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。) |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端