March 19, 2009 at 5:58 am
I have two jobs.
One I want to run on the 1st Sunday of the month. I got this one.
The second job I need to run on all other Sundays of the month.
The options at 1st, 2nd, 3rd, 4th and Last.
There are 4 months in the year that have 5 Sundays.
My question is does the "Last" Sunday mean the 5th Sunday?
In other words, the second job set up to run on the 2nd, 3rd, 4th, Last Sunday.
On the Months that have 5 Sunday, I figures this will work.
What about the months that only have 4 Sundays? Will the scheduler only run either the 4th or Last or will it run both the 4th and Last steps?
March 19, 2009 at 7:30 am
I believe that will work.
If you have a test server (or desktop installation), you might try setting a simple job up that does something like insert a row into a table with a time stamp. Then set the date on the test machine to one of the days that is both 4th and last in the month and see what the jobs do. That way, you'll really know what it does.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply