Scheduler Not Following Pattern

[pmdzuba]

I have scheduled a transaction within the hourly tab to run between 3pm - 4pm and to run every 5 minutes within that range.  The job does start at 3:00pm and runs every 5 minutes but does not stop at 4:00pm.  Does somebody know why?

[former_member193328 · Accepted solution]

Hi Paul

I guess you got a pattern like 0 */5 15-16 * * * for your scheduler? If yes the issue is that 15-16 means 15 and 16 is included. Hence your scheduler does not stop at 4 PM. Rather it stops before 5 PM.

So your patter should be one of the below

0 */5 15 * * * -- When it is every 5 mins.

Or

0 5,10,15,20,25,30,35,40,45,50,55 15 * * * -- Use when the gap is not uniform.

I did not find an easy way to configure this with the pattern wizard. You can paste this pattern in the field directly and save.

Regards

Partha

[pmdzuba · Accepted solution]

The 2nd pattern is what worked.  The first you were right that the pattern is 0 */5 15-16 * * * and the wording is (on 0th Second at every 5 Minutes between 3pm and 4pm) which is what I want but the execution schedule shows this beyond 4:00pm:

May 5, 2014 3:50:00 PM EST

May 5, 2014 3:55:00 PM EST

May 5, 2014 4:00:00 PM EST

May 5, 2014 4:05:00 PM EST

May 5, 2014 4:10:00 PM EST

If watching this it history does show jobs running after 4:00pm.  If I change to the pattern you suggest, then the job will run every 5 minutes for every hour.