Running Subscriptions

Once you have kicked off your report subscription you might want to see the status. Again, if you don’t want to log onto the SQL Server Reporting Services web interface you can do this with a simple SQL Query. /*Active (Running) subscriptions*/ SELECT c.name, rs.scheduleid AS jobid, sub.DESCRIPTION, sub.laststatus FROM reportserver..catalog c INNER JOIN reportserver..subscriptions subON (c.itemid = sub.report_oid) INNER JOIN reportserver..activesubscriptions asubON (sub.subscriptionid = asub.subscriptionid) INNER JOIN reportserver..reportschedule rsON (sub.subscriptionid = rs.subscriptionid) This query will return the Report [...]

Read Full Post »

SQL Server Reporting Services Jobs

This script is a useful one that I have at my office.  I use it often to find all the SQL Server Reporting Services scheduled reports that exist on a SQL Reporting Server instance.  It list the job name, job description, the scheduled date and time and the status of the last time it was [...]

Read Full Post »