February 27, 2009 at 3:46 pm
There is a weekly data driven subscription that is reported to have been completed without errors according to the status and in the Server Logs was well.
The list of recipients is populated via a table.
I see that one of the records has an empty email address.
Would that mean that all mailings following that record would fail ?
I do not have access to teh email server or its smtp logs...
Is there a place on the SQL Reporting server that I can browse to find out ?
BOL says data driven subscriptions can not be monitored. But if you have any thing to share as to what happend to that subscritpion , it will help me a lot.
( MSDN tip from codeplex to install a db to pull this form reportin gserver db is not an option right now for me for "security reasoons " !!!)
Thanks
March 2, 2009 at 8:21 am
Are the users stating they did not receive it?
Can you set up a new subscription with the same technique, pulling from a table that only include your email and a blank email? play with the order and see how it works?
The real answer would be in the SMTP logs... does your server use itself as the SMTP server or does it connect to another machine? IF it uses itself you should be able to see badly addressed emails in the badmail folder. One would think it would be just as if the email was created with a bad address, the SMTP server would send to all of the addresses and the one that failed would bounce back, but that's only a guess.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply