job

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

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]…