Solved

reporting services launch subscription on demand

Posted on 2006-10-31
2
632 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

777 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