FrequencySubDay Property (SQL-DMO)

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

Applies To

Schedule Object

Syntax

object.FrequencySubDay [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying a daily occurrence for the scheduled activity as described in Settings

Settings
Constant Value Description
SQLDMOFreqSub_Hour 8 Schedule reflects an activity scheduled using an hour as the unit
SQLDMOFreqSub_Minute 4 Schedule reflects an activity scheduled using a minute as the unit
SQLDMOFreqSub_Once 1 Schedule reflects an activity that occurs once on a scheduled day
SQLDMOFreqSub_Unknown 0 Subunits are invalid for the scheduled activity

Remarks

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.

Data Type

Long, enumerated.

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFrequencySubDay(SQLDMO_FREQSUB_TYPE* pRetVal);

HRESULT SetFrequencySubDay(SQLDMO_FREQSUB_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.