SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter...


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

Author
Message
Narayana_17
Narayana_17
SSC-Enthusiastic
SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)

Group: General Forum Members
Points: 155 Visits: 135
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
Jason Selburg
Jason Selburg
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6754 Visits: 4115
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 you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Narayana_17
Narayana_17
SSC-Enthusiastic
SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)

Group: General Forum Members
Points: 155 Visits: 135
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
Narayana_17
SSC-Enthusiastic
SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)

Group: General Forum Members
Points: 155 Visits: 135
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
Jason Selburg
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6754 Visits: 4115
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 you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Michael | Fuel9
Michael | Fuel9
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 102
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search