I am cleaning hundreds of orphaned report subscription jobs and wrote this:

select 'exec sp_delete_job '+job.name
from msdb.dbo.sysjobs job
inner join msdb.dbo.sysjobsteps jst on job.job_id=jst.job_id
left join reportserver.dbo.ReportSchedule rs on cast(rs.ScheduleID...

• This reply was modified 4 years, 6 months ago by  Leif Peterson.

This was very helpful.  We upgraded packages from 2008 to 2016 and they worked for the most part.  However, tasks from the third party library from vendor CozyRoc had apparently...

Thanks for the replies. We thought we were missing something. None of the books or articles that describe it give any specifics on implementing or the limitations....

After spending several evenings working out security issues I finally got the Report Builder working only to discover that my views did not make it from my "view" to my...