ReplicationAgentSchedule.FrequencyInterval Property

Article
12/03/2008

Gets or sets the interval between occurrences of a scheduled activity.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntax

'Declaration
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)

Property Value

An Int32 value.

Remarks

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.

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via