Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to different email addresses

Question

Post reply

Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to different email addresses

Narayana_17

SSC Eights!

Points: 933
More actions
October 14, 2010 at 5:48 am

#227847

Hi Guys,
Can anyone tell me how to Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to(having) different email addresses using standard subscriptions.
Note:Standard Edition is not having the datadriven subscription.
Any Help is greately appreciated
Thanks
Narayana

Viewing 6 posts - 1 through 5 (of 5 total)

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

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

http://www.sqlservercentral.com/articles/Development/2824/

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Narayana_17 SSC Eights! Points: 933 More actions · Answer 2

Hi Jason,

Thanks for the response.

I ran this procedure in cursor so that i can generate reports for all the records in result set of the cursor.

and the time delay is different for every record.For some records its taking less time and for some records its take more time.

So the time delay code "WaitFor Dealy '00:00:02'" causing a problem. If i put small delay its giving error message

---------

Msg 22022, Level 16, State 1, Line 0

SQLServerAgent Error: Request to run job C5E96594-9876-42FE-9324-5F6DF8F5CC0B (from User Narayana) refused because the job already has a pending request from User Narayana.

---------

I dont want to put more delay for small reports which takes vary less time.

How could i resolve this problem

Please help me in this issue

Thanks

Narayana

Narayana_17 SSC Eights! Points: 933 More actions · Answer 3

Hi Jason,

else

Is it possible to do like this

untill current session job executes successfully

start loop

waitfor delay '00:00:02'

check the jobstatus of current session

end loop

and the next record excutes procedure and generates report with its values

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 4

your second approach seems more effective.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Michael | Fuel9 Valued Member Points: 68 More actions · Answer 5

Hello Narayana,

You might want to check out our notification framework called Boomerang. With this framework you can create notifications (by emailing, faxing, printing etc.) that are static or dynamic with just a few lines of SQL code. The framework also offers a service oriented infrastructure to manage all your outgoing and incoming notifications. You can learn more on here.

Good luck

Michael

Fuel9