All Others Bring Data

SQL Job Names Used by Reporting Services Subscriptions

There are a number of scenarios where you might need to restart a scheduled report in reporting services 2005. Unfortunately, the SQL jobs that are created by reporting services do not carry intelligible names.

This code snippet will show which SQL jobs need to be run in order to restart a failed subscription.


SELECT a.name job_name, d.name schedule_name, d.path, c.description, c.laststatus, c.lastruntime
FROM msdb..sysjobs a
JOIN reportserver..reportschedule b ON a.name=cast(b.scheduleid as nvarchar(255))
JOIN reportserver..subscriptions c ON b.subscriptionid=c.subscriptionid
JOIN reportserver..catalog d ON c.report_oid=d.itemid
ORDER BY c.lastruntime desc


Shane Reporting Services 2005