Unexpected behavior of SQL Server Agent on weekly schedules

Hello.

I have experienced a little problem concerning job scheduling.

Today (on Monday 01/13/2014) I have created a job with the following schedule: 

Schedule type: recurring,  occurs: weekly, recurs every: 2 weeks, on: Monday, Occurs once at: 16:00:00 (or any time in the future), start date: 01/06/2014, no end date.

After that I have the next job launch planned on today 01/13/2014, but not on the next week 01/20/2014.

Logically, if I count two weeks since the last week 01/06/2014 I must get my launch on 01/20/2014, but not on 01/06/2014.

So, is the job next launch calculated properly (if yes, why?) or this behaviour may be concerned as a bug? 

SQL Server version: 2012 Developer edition.

Best regards,

Tatiana.

 


January 13th, 2014 4:42am

Its an expected behaviour. Startdate should be a future date, hence you can change it to tomorrow "14th Jan 2014" where as you can see the next date is 20th Jan 2014.
Free Windows Admin Tool Kit Click here and download it now
January 13th, 2014 4:49am

We are trying to resolve a problem of calculating the laucnhes map, so as we could predict the next launch.  It is not prohibited by SQL Server agent to create schedules with the start date in the past so we have to handle this issue as well. Could you, please, explain how is the next launch calculated in the described case?
January 13th, 2014 5:35am

AS your startdate is a past day, it would take the first occurence as 13th Jan as starting date and there afer the schedule takes like 27th Jan as next schedule. If you change the startdate as 14th, then it would take 20th Jana s next and there after two week calculation.

I am not sure, if you can change the startdate as 5htJan would change the schedule as per your needs. Please check the same.

Free Windows Admin Tool Kit Click here and download it now
January 13th, 2014 5:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics