ReplicationAgentSchedule.FrequencyInterval Property
Gets or sets the interval between occurrences of a scheduled activity.
네임스페이스: Microsoft.SqlServer.Replication
어셈블리: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)
구문
‘선언
Public Property FrequencyInterval As Integer
public int FrequencyInterval { get; set; }
public:
property int FrequencyInterval {
int get ();
void set (int value);
}
/** @property */
public int get_FrequencyInterval ()
/** @property */
public void set_FrequencyInterval (int value)
public function get FrequencyInterval () : int
public function set FrequencyInterval (value : int)
속성 값
An Int32 value.
주의
The FrequencyType property determines the interval units. For example, if FrequencyType is set to daily and FrequencyInterval is set to 3, the scheduled activity occurs every 3 days.
Values are combined by using the bitwise logical OR operator ( | ) to set a combination of relative intervals.
If FrequencyType is set to MonthlyRelative, the FrequencyRelativeInterval property specifies the time of the month relative to the first day of the month, and the FrequencyInterval property specifies the day within that interval. For example, if FrequencyRelativeInterval is set to Second and FrequencyInterval is set to Friday, the scheduled activity occurs on the second Friday of every month.
Hexadecimal value |
Daily |
Weekly |
Monthly |
MonthlyRelative |
0x0001 |
Every day |
Sundays |
First |
Sunday |
0x0002 |
Every 2 days |
Mondays |
Second |
Monday |
0x0003 |
Every 3 days |
Sundays and Mondays |
Third |
Tuesday |
0x0004 |
Every 4 days |
Tuesdays |
Fourth |
Wednesday |
0x0005 |
Every 5 days |
Tuesdays and Sundays |
Fifth |
Thursday |
0x0006 |
Every 6 days |
Mondays and Tuesdays |
Sixth |
Friday |
0x0007 |
Every 7 days |
Sundays, Mondays, and Tuesdays |
Seventh |
Saturday |
0x0008 |
Every 8 days |
Wednesdays |
Eighth |
Day |
0x0009 |
Every 9 days |
Sundays and Wednesdays |
Eighth |
Weekday |
0x000A |
Every 10 days |
Mondays and Wednesdays |
Tenth |
Weekend day |
0x0010 |
Every 16 days |
Thursdays |
Sixteenth |
|
0x0020 |
Every 32 days |
Fridays |
|
|
0x003E |
Every 62 days |
Weekdays |
|
|
0x0040 |
Every 64 days |
Saturdays |
|
|
0x0041 |
Every 65 days |
Weekends |
|
|
0x007F |
|
Every day |
|
|
This namespace, class, or member is supported only in version 2.0 of the .NET Framework.
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
ReplicationAgentSchedule Class
ReplicationAgentSchedule Members
Microsoft.SqlServer.Replication Namespace