FrequencySubDay Property

SQL-DMO

SQL-DMO

FrequencySubDay Property

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

Applies To
Schedule Object
Syntax

object.FrequencySubDay [= value]

Part

object

Expression that evaluates to an object in the Applies To list

value

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 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 unit.
SQLDMOFreqSub_Unknown 0 Subunits are invalid for the scheduled activity.
SQLDMOFreqSub_Valid 13 Mask to test schedule subfrequency validity.

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.