Archive

Archive for the ‘Reporting Services 2005’ Category

Restart a Scheduled Report in Reporting Services 2005

February 2nd, 2009
Comments Off
SQL Job Names Used by Reporting Services Subscriptions

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

Reporting Services 2005