Solved

SSRS cache refresh and subscription schedule via ETL

Posted on 2013-05-17
1
385 Views
Last Modified: 2013-08-20
I have an ETL  that runs daily to refresh data on the report server. the ETL takes different time based on how much new data is there to process, so it finishes at a  different time each day. Therefore I want the SSRS cache refresh and subscriptions to run as at the end of my ETL process.  How can I accomplish that? What queries to run from the ETL to run a subscription and cache refresh.
0
Comment
Question by:patd1
1 Comment
 
LVL 1

Accepted Solution

by:
Prakash_Kavar earned 500 total points
ID: 39204148
There is a job created  in SQL server based on your subscription and cache refresh schedule so identify it and take job id from there and put one task  at the end in your etl package ,so it will execute both job based on your sql query

Use  EXEC sp_start_job stored procedure in which job_id or job_name you need to provide
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

896 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now