SQL

How to find the SSRS Job Name with the Report Name SQL

How to find the SSRS Job Name with the Report Name SQL

Highlights

  • .
  • .
  • .

In order to check the status of the SSRS report subscription jobs, status, and the last run time, run the following SQL script against the MASTER DB.  It will list:

  • report id
  • report name
  • last status
SELECT
c .Name AS ReportName
, rs . ScheduleID AS JOB_NAME
, s . [Description]
, s . LastStatus
, s . LastRunTime
FROM
ReportServer ..[Catalog] c
JOIN ReportServer .. Subscriptions s ON c. ItemID = s. Report_OID
JOIN ReportServer .. ReportSchedule rs ON c. ItemID = rs. ReportID
AND rs . SubscriptionID = s . SubscriptionID

 
This will give you output in the SQL Management Studio in Grid view of your report name and then also allow you to match this up with the very non-intuitive JOB_NAME.  Once you have this information, you can then check your Job logs for the jobs in which you would like to see the history and more details about previous job runs.

To do this simply:

  • Look under SQL Server Agent in Management Studio
  • Jobs
  • Right-click the job and choose to view history

Subscribe to VirtualizationHowto via Email 🔔

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com and has over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, Brandon has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.