Avatar of ssrs1212014

asked on 

How to maintain SQL Server Reporting Services job subscription in SQL Server Agent job history

SSRS subscription jobs under SQL Server AgentUsing SQL Server 2008 R2 and SQL Server Reporting Services (SSRS)

When I schedule an SSRS report in SQL Server Reporting Services - Report Manager, it creates a subscription in SSRS.
In Microsoft SQL Server Management Studio under SQL Server Agent a new Job is added with a cryptic job name.
Please see attached snapshot for example.

How do I clean up those SSRS subcription jobs under SQL Server Agent?
For example, what if I only wanted to maintain 30 days worth of job history?
What procedure do I follow?

Thank you.

Microsoft SQL ServerSSRSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Ryan McCauley

8/22/2022 - Mon