Partager via


ReplicationAgentSchedule.FrequencyInterval Property

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

Espace de noms: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntaxe

'Déclaration
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)

Valeur de propriété

An Int32 value.

Notes

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.

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

ReplicationAgentSchedule Class
ReplicationAgentSchedule Members
Microsoft.SqlServer.Replication Namespace