?
Solved

SSRS cache refresh and subscription schedule via ETL

Posted on 2013-05-17
1
Medium Priority
?
394 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
Prakash_Kavar earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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