Solved

SSRS cache refresh and subscription schedule via ETL

Posted on 2013-05-17
1
389 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 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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…

733 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