• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

reporting services launch subscription on demand

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!


1 Solution
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


DavidGreenfieldAuthor Commented:
Yeah that's what I thought might be the only way to do it, I shall give that a go now!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now