Warning: ob_start(): non-static method wpGoogleAnalytics::get_links() should not be called statically in /home/scolin/blog.scolin.com/wp-content/plugins/wp-google-analytics/wp-google-analytics.php on line 259
reporting services « from the gut
Shane on September 17th, 2007

Wondering which SQL Job runs which subscription? Here’s how to find out. select a.name, d.name, d.path, c.description, c.laststatus, c.lastruntime from msdb.dbo.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

Continue reading about File Under: Reporting Services Tricks