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 [...]
Posts Tagged ‘query’
Running Subscriptions
Posted in Reporting Services, SQL Server, tagged query, Reporting Services, SQL Server on January 15, 2012 | Leave a Comment »
Using the Job ID to rerun a subscription
Posted in SQL Server, tagged query, Reporting Services, SQL Server on January 15, 2012 | Leave a Comment »
The previous post showed a sql script that is useful for finding all your Reporting Services jobs. Now that you have that information, lets say you’d like to kick off a scheduled report that either already ran, or you’d like to run again but you don’t want to have to step through all the settings [...]
