There are a number of fields in the sysjobs_schedules table that are confusing and not documented very well. One of those fields is the freq_interval when dealing with weekly/monthly schedules.
Very quickly (and I will detail a bit more later in another post) the freq_interval column when posting a ‘weekly’ job, to run on specified days, will add the day values of the numbers together;
The numbers are:
1 Sunday
2 Monday
4 Tuesday
8 Wednesday
16 Thursday
32 Friday
64 Saturday
So if you have a job that runs mon-fri, the value of the field will be 62. That’s 2+4+8+16+32 = 62.
Enjoy.