SSRS cache refresh and subscription schedule via ETL

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.
patd1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Prakash_KavarConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.