Partager via


JobSchedule.FrequencyRecurrenceFactor Property

Gets or sets the number of weeks or months between scheduled jobs for schedules with a weekly or monthly frequency type, respectively.

Espace de noms: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public Property FrequencyRecurrenceFactor As Integer
public int FrequencyRecurrenceFactor { get; set; }
public:
property int FrequencyRecurrenceFactor {
    int get ();
    void set (int value);
}
/** @property */
public int get_FrequencyRecurrenceFactor ()

/** @property */
public void set_FrequencyRecurrenceFactor (int value)
public function get FrequencyRecurrenceFactor () : int

public function set FrequencyRecurrenceFactor (value : int)

Valeur de propriété

An integer value that specifies the number of units of the unit type indicated by the FrequencyTypes property, which specifies the time between scheduled jobs.

Notes

The FrequencyRecurrenceFactor property is evaluated for JobSchedule objects with FrequencyTypes values FrequencyType.Weekly, FrequencyType.Monthly, and FrequencyType.MonthlyRelative.

For example, when FrequencyTypes is FrequencyType.Weekly, FrequencyRecurrenceFactor indicates a number of weeks. Setting FrequencyRecurrenceFactor to 2 specifies that the job is scheduled to occur every other week.

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Exemple

How to: Create a Job with Steps and a Schedule in Visual Basic .NET

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

JobSchedule Class
JobSchedule Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

Autres ressources

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatisation des tâches administratives (SQL Server Agent)
sp_add_schedule (Transact-SQL)