Condividi tramite


FrequencySubDay Property

Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa caratteristica in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The FrequencySubDay property specifies the unit for the least significant portion of a scheduled activity.

Sintassi

object
.FrequencySubDay [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer that specifies a daily occurrence for the scheduled activity as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFrequencySubDay(SQLDMO_FREQSUB_TYPE* pRetVal);
HRESULT SetFrequencySubDay(SQLDMO_FREQSUB_TYPE NewValue);

Settings

Constant

Value

Description

SQLDMOFreqSub_Hour

8

The schedule reflects an activity scheduled using an hour as the unit.

SQLDMOFreqSub_Minute

4

The schedule reflects an activity scheduled using a minute as the unit.

SQLDMOFreqSub_Once

1

The schedule reflects an activity that occurs once on a scheduled unit.

SQLDMOFreqSub_Unknown

0

Subunits are not valid for the scheduled activity.

SQLDMOFreqSub_Valid

13

A mask to test schedule subfrequency validity.

Osservazioni

The FrequencySubDay property specifies the unit for schedule evaluation for schedules for activities occurring several times in one day. Set the FrequencySubDayInterval property to specify the number units.

Applies To: