Solved

reporting services launch subscription on demand

Posted on 2006-10-31
2
634 Views
Last Modified: 2008-02-01
Hi all

I want to launch on demand from SQL Server 2005 within a sproc a data driven subscription created in Reporting Services 2005.

Is the best way to do this to create the data driven subscription as usual then just execute the job within the sproc, or is there a better and cleverer way?

Could be an easy 500 points up for grabs!

Thanks

David
0
Comment
Question by:DavidGreenfield
2 Comments
 
LVL 11

Accepted Solution

by:
regbes earned 500 total points
ID: 17842073
Hi DavidGreenfield,

Try take the command text drom the agent job and run it from within your SP with xp_cmdshell or exec or sp_execsql

HTH

R.
0
 

Author Comment

by:DavidGreenfield
ID: 17842210
Yeah that's what I thought might be the only way to do it, I shall give that a go now!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question