Propriedade do RDL JobSchedule.FrequencyRecurrenceFactor
Gets or sets the number of weeks or months between scheduled jobs for schedules with a weekly or monthly frequency type, respectively.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
<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 da propriedade
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.
Comentários
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.
Exemplos
Agendando tarefas administrativas automáticas no SQL Server Agent
Consulte também
Referência
Namespace Microsoft.SqlServer.Management.Smo.Agent