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
Add as a preferred source on Google
Google is updating how articles are shown. Don’t miss our leading home lab and tech content, written by humans, by setting Virtualization Howto as a preferred source.
About The Author
