Video Screencast Help

BE 2012 - Run Job At Certain Hourly Intervals Between Certain Hours Of The Day - Part 2

Created: 15 May 2013 • Updated: 16 May 2013 | 1 comment
Language Translations
pkh's picture
+4 4 Votes
Login to vote


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.

Comments 1 CommentJump to latest comment

lebelflash's picture


thanky you, i will try it.



Login to vote