Solved

Call an SSRS subscription from stored procedure

Posted on 2014-11-06
1
1,769 Views
Last Modified: 2014-11-06
Hi all,

I have a simple question, is it possible to call (and email) a report in SSRS by calling a stored procedure?

There reason for this (and not just using the schedule) being that we may want to send the report only under certain circumstances, such as there actually being data to report.

We are using SQL Server 2008 R2.

Any help is greatly appreciated.

Thanks.

resourcesys.
0
Comment
Question by:resourcesys
1 Comment
 

Accepted Solution

by:
resourcesys earned 0 total points
ID: 40426262
Hi all,

Found out that when you create a subscription a job is created in SQL Server Agent. So, if you find out the name of the job, you can run the following anytime to run the subscription:

USE msdb
EXEC sp_start_job @job_name = ‘D4EF7E0D-7FFB-47A5-A87A-D63F2D242A06′


resourcesys.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 70
T-SQL: "HAVING CASE" Clause 1 25
insert wont work in SQL 14 21
I have a SQL Select with a where clause that has an issue. 6 38
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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