HI
The issue is i have created data driven subscription. The status says " Done: 9 processed of 9 total; 0 errors."
It is supposed to deliver email to 9 people but only 8 are receiving the email. The person also searched in the mailbox with subject of email notification thinking that the email might be getting delivered to some other folder but of no success.
I have already gone through the below thread and followed few steps mentioned there:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b4176895-5ef3-488d-8c68-57ef287a784c/datadriven-subscription-doesnt-send-out-an-email-but-job-history-shows-its-successfull?forum=sqlreportingservices
I checked the ReportServerSErvice Log in location (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles as mentioned in above thread. But no errors encountered there.
Also checked the below tables, but no records found there . The tables are empty.
Checked the table ExecutionLogStorage and ExecutionLog2 , for given reportID and there are 9 records created at that given time and all have status of rsSuccess.
Need urgent help on how to where the issue lies.
Thanks