question

gottogetup avatar image
gottogetup asked

Subscription Email failing SQL R2 CU1

I see the job runs but the last run never gets updated. I can go into management studio and see the job completed there but nothing. Also if I put a notification email on the job for success and run the job from Studio I get email. If I run from report server I don't even get the email notification. Please help, Rich
subscriptionsemail
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Noonies avatar image Noonies commented ·
I had a similar issue and it was due to the server that was not sending the email did not have SMTP email relay. Once the server was added I had no issues. Not sure if this helps!
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered
I would start by reviewing the "subscriptions are not processed" section of the link below.. [MDSN][1] [1]: http://msdn.microsoft.com/en-us/library/ms159171.aspx You could also check the SSRS log file(s) and the ExecutionLog table for more information.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.