SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is there any way to verify that an email delivered by a data driven subscription has been received...


Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user?

Author
Message
jshahan
jshahan
Mr or Mrs. 500
Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)

Group: General Forum Members
Points: 550 Visits: 2086
Hello

We are using a data driven subscription (SQL 2008 R2) to email recipient specific data to an exchange server in an external domain.

All of the users but one say they receive their emails just fine.

We confirmed that we have proper email address information for the user in question and that the report runs fine when you manually specify that user. There are no error reported by the subscription itself. They also say that email filters are not the issue.

Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user in an external domain?

Thanks in advance for any advice.
Fraggle-805517
Fraggle-805517
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 1512
The database isn't a mail server, so it has no way to register if someone received an email.

Your two best bets would be
1) Contact your network admin and have him review the email logs to see if it is getting blocked, etc. This should be pretty easy for them to do (well it is for my network guys, but it might be dependent upon mail configuration and such).
2) Check the Reporting Service logs to see if there is a message telling that it failed for some reason. These logs are a bit different than the SQL Logs and Mail logs and often contain additional information.

Generally speak, the ssrs logs are found her: %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
jshahan
jshahan
Mr or Mrs. 500
Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)

Group: General Forum Members
Points: 550 Visits: 2086
I had a hunch that I was going to need to go this route. Thank you for the very practical advice.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search