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