Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to different email addresses Expand / Collapse
Author
Message
Posted Thursday, October 14, 2010 5:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 3:47 AM
Points: 19, Visits: 121
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
Post #1004259
Posted Thursday, October 14, 2010 6:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 12:51 PM
Points: 2,717, Visits: 3,843
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
Post #1004319
Posted Thursday, October 14, 2010 7:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 3:47 AM
Points: 19, Visits: 121
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
Post #1004362
Posted Thursday, October 14, 2010 7:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 3:47 AM
Points: 19, Visits: 121
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
Post #1004382
Posted Thursday, October 14, 2010 8:51 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 12:51 PM
Points: 2,717, Visits: 3,843
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
Post #1004442
Posted Saturday, December 25, 2010 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:13 AM
Points: 8, Visits: 101
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
Post #1039201
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse