Data Driven Subscription Schedule Problem
I have created a data driven subscription and have set up the subscription to send on 28th February only.I have done this by creating a Monthly subscription. I have set February = True within the list of months, and specified "On Calendar Days" = 28.
I expected this to run on Feburary 28th only, but it ran yesterday, on March 28th. Can anyone suggest why this happened?
Many Thanks,Katie
March 29th, 2010 1:21pm
Hi Katie,
Generally, a subscription won't run in a unexcepted day. In this case, could you please help to check "March" is unchecked?
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2010 2:42pm
I have checked and double checked that March is not selected.
After speaking to a colleague, I find that this happened for them also (i.e. they have a report to send on 28th of February only, and it unexpectedly sent on 28th March).
Any thoughts?
March 31st, 2010 4:12pm
I had this same problem as well. We set up a report to run the 1st day of the month on quarter months (March, June, September, and December). The setup was done on 09/23/2011 with a start date of 9/23/2011. The report ran October 1st, but was
not supppse too. October was not a month that was checked.
I see that there was no follow up by Microsoft. Nice.
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 9:38am
I am running into this problem as well... We have the reports setup to run on a quarter month on days 1-30 and I just got a report generated today, 2/14 when the months selected were Jan/Apr/Jul/Oct. See screen show below
Any ideas?
March 3rd, 2012 12:42pm
Please see my screen shot attached to this thread, I was able to post what the DDS has as the schedule and the report generated today....
Free Windows Admin Tool Kit Click here and download it now
March 3rd, 2012 1:05pm
For those that are running into the same problem, I have opened a connect ticket with MS...
https://connect.microsoft.com/SQLServer/feedback/details/725290/data-driven-subscription-schedule-problem
March 3rd, 2012 1:44pm