Solved

SSRS cache refresh and subscription schedule via ETL

Posted on 2013-05-17
1
379 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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
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…
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 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

14 Experts available now in Live!

Get 1:1 Help Now