Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jholovacs
Posting Yak Master
163 Posts |
 Posted - 2008-12-02 : 11:45:31
|
| An associate of mine created a single report with 3 different email subscriptions:1 subscription emails the report at 7:35 on days 2-30 in April, June, September, and November.1 Subscription emails the report at 7:30 on days 2-31 in January, March, may, Jul, August,October, and December.1 Subscription emails the report at 7:25 on days 2-28 in February.Obviously, the intent of these subscriptions is to mail the report on every day EXCEPT the 1st of each month.Interestingly enough, today (being the second of December) two emails were sent, one from the 30-day subscription, and one from the 31-day subscription, which caused a certain level of consternation. The schedules clearly list the mutually exclusive months they are to run, but it seems like the subscription scheduler completely ignored the month filter.I cannot imagine how this would be behavior by design, and I am at a loss as to why this is. Is this a bug? Can anyone recreate this? I have looked online and found no mention of this sort of behavior.___________________________Geek At Large |
|
|
jholovacs
Posting Yak Master
163 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-12-02 : 14:40:56
|
oh come on! if they fixed every bug, you'd be out of a job as everything would work with a press of a button.  ___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
|
|
|
|
|
Scheduled subscription bug?