April 21, 2006 at 3:41 pm
Hi I'm hoping someone here can answer this question for me. If I schedule a DTS package to run on the 29th of every month, it would work correctly on 2/29 when it is a leap year, but when it's not a leap year, will DTS automatically schedule it to run on the 1st of March or will it not run at all for that month since 2/29 occur? I am assuming it would just run it on the 1st of March when it's not a leap year, but I cannot seem to find confirmation anywhere....
Thanks in advance for your help!
Rene
April 24, 2006 at 2:26 am
I'm pretty sure that if the date does not exist then dts will not run it.
If you can afford to wait for a week, try scheduling something to run on 31st month. As April does not have that date, you will see one wy or another.
The reason I suspect that it does not run is that it is possible to schedule a dts package for the last day of the month. This would probably be a fix to get around the days of a month problem.
Either way, I would rather code the package to be certain. Just create a stored procedure to return a yes/no to run on a certain day and make this the first step of the package.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply