FrequencySubDayInterval Property
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The FrequencySubDayInterval property specifies the number of units elapsed between one scheduled activity and a second occurrence of the same activity.
Sintassi
object
.FrequencySubDayInterval [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A long integer
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFrequencySubDayInterval(LPLONG pRetVal);
HRESULT SetFrequencySubDayInterval(LONG NewValue);
Osservazioni
FrequencySubDayInterval has meaning only if the FrequencyType property of the Schedule object is SQLDMOFreq_Daily and the FrequencySubDay property is SQLDMOFreqSub_Hour or SQLDMOFreqSub_Minute.
For example, to schedule an activity for daily occurrence, every 15 minutes, set FrequencyType to SQLDMOFreq_Daily, set FrequencySubDay to SQLDMOFreqSub_Minute, and then set FrequencySubDayInterval to 15.