I want to run my SQL log backup or increment backup job on the hour every x hour between 9 a.m. and 5 p.m. during the week-days.
Earlier I have writtten an article on how to solve this problem
However, if you do not like to have to deal with BEMCLI and the Windows scheduler, below is an alternative way to solve the problem
Suppose I want to run an incremental job every 1 hour between 9 a.m. and 12 p.m. (noon) from Monday to Friday.
1) Create the incremental job for 9 a.m.
Create an incremental job and use the days recurrance schedule to make the job make the job run at 9 a.m. each weekday.
2) Create the second incremental job for 10 a.m.
3) Create the incremental jobs for 11 a.m. and 12 noon.
You would then end up with a job looking like this.
Notice that you now have 4 incremental jobs running each day every hour from 9 a.m. to 12 noon.
If you want to run incremental jobs for a longer period, you would have to add in more jobs. This method is messier than the other method described in my other article, but you would not have to learn BEMCLI or use the Windows scheduler.