Compartir a través de


JobSchedule.FrequencyRecurrenceFactor Propiedad

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo.Agent
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FrequencyRecurrenceFactor As Integer 
    Get 
    Set
'Uso
Dim instance As JobSchedule 
Dim value As Integer 

value = instance.FrequencyRecurrenceFactor

instance.FrequencyRecurrenceFactor = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int FrequencyRecurrenceFactor { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int FrequencyRecurrenceFactor {
    int get ();
    void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member FrequencyRecurrenceFactor : int with get, set
function get FrequencyRecurrenceFactor () : int 
function set FrequencyRecurrenceFactor (value : int)

Valor de la propiedad

Tipo: System.Int32
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.

Comentarios

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.

Ejemplos

Programar tareas administrativas automáticas en el Agente SQL Server

Vea también

Referencia

JobSchedule Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo.Agent

Otros recursos

Tareas administrativas automatizadas (Agente SQL Server)

sp_add_schedule (Transact-SQL)