smtp mail

Question

smtp mail

ramana3327

SSCoach

Points: 19722
More actions
October 12, 2014 at 7:00 am

#294114

Hi All,
I need to find when we did subscription, why the person didn't receive email.
How to find the ssrs report emails are working?
When we subscribed the report it will send email. How to find on what time that report sent mail? Is that use smtp or database mail
October 12, 2014 at 11:49 pm

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 1

ramana3327 (10/12/2014)
Hi All,
I need to find when we did subscription, why the person didn't receive email.
How to find the ssrs report emails are working?
When we subscribed the report it will send email. How to find on what time that report sent mail? Is that use smtp or database mail

I'm new to SSRS myself (and I hate it but have been compelled to using it) but take a look at the SSRS related databases (I forget their names and not near the machine it's been setup on but SSRS creates two databases with almost identical names, one having an _TEMP suffix added). There are a shedload of logging tables in those databases that even cover the performance aspects of the reports and certainly the subscription aspects. Spend some time looking them up in Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 2

p.s. And, not to be insulting in any way, shape, or form, if you don't know what the product called "Books Online" actually is, please post back. It's one of the most useful tools there is this side of Google.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)