SSRS report not getting mailed, inside TRANSACTION

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SSRS report not getting mailed, inside TRANSACTION

Author

Topic

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2010-07-13 : 03:23:58

I am mailing my SSRS report by calling the sp_test procedure which contains the "exec msdb..sp_start_job @job_name = @scheduleID" command in it for mailing the report


BEGIN Transaction
exec sp_test                                      
@scheduleID='B9004.......',                      
@emailTO = 'nd@xxx.com'   
COMMIT Transaction

The problem is the report is not getting mailed when i am calling the procedure inside the the Begin Transaction clause

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-13 : 16:43:47

hi.

i don't see the point of your work.
first of all, SSRS is user-end tool for viewing data via Report Manager.
secondly, if you want to mail the report content, you can use built-in subscription function to do just that -> send on email the content of the report.
and thirdly, if you want to send email when report is generated, i don't see any other reason for doing that, than auditing/logging reasons -> all auditing information in ReportManager are available in ReportServer database (where your report manager is located) in table ExecutionLog.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources