Showing results for 
Search instead for 
Did you mean: 
   VIP    Certified



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.

BE 2012 - incr 1.png

2) Create the second incremental job for 10 a.m.

BE 2012 - incr 2.png

3) Create the incremental jobs for 11 a.m. and 12 noon.

You would then end up with a job looking like this.

BE 2012 - jobs within a time period.png

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.


Level 3



thanky you, i will try it.





Version history
Last update:
‎05-15-2013 10:10 PM
Updated by: