SQL Server 2008 Books Online (October 2009)
Scheduling Subfrequency Constants (SQLDMO_FREQSUB_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Scheduling subfrequency constants specify a smaller scheduling unit for specific schedule frequencies. For example, an administrative or replication task can be scheduled to occur on the days of the business week. Using subfrequency constants, the task can be scheduled for execution every eight hours on each scheduled day.

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.

See Also

Reference

FrequencySubDay Property

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker