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

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

Other recent topics Other recent topics