How are SQL Server sysschedules intervals calculated?

This table: sysschedules

If freq_typeequal to 8 (weekly), then freq_intervalequal to 1,2,4,8,16,32,64 for Su, M, T, W, Th, F, S.

But when it freq_typeis 32 (monthly relative), then it freq_intervalis 1,2,3,4,5,6,7,8,9,10 for Su, M, T, W, Th, F, S, weekday, weekend.

Why is this? Are there any calculations to reduce query complexity?

If so, how? (sry, if I don’t know what is happening, creating a system of recurring events melts my brain)

+5
source share
1 answer

freq_type 8, , freq_interval. , . . -, , , 2 + 8 + 32 = 42. ( , )

freq_type 32, - , , . , .

+5

All Articles