Posted in October 2012

Reporting Services Subscription Status

Thanks to some SMTP changes, we’ve had tons of reports fail recently!!!! I needed a quick an easy way to see the subscription status of a report, and here is what I have devised: The code above will show ALL reporting services reports on Reporting Services 2005 and 2008, and will give the last 36 … Continue reading

BIDS Helper

I needed to be able to clear my reporting services data cache to get accurate loading times for reports. Unfortunately, you have to manually find the files and delete them, or run command line text to clear them. After a little research, I found an awesome tool which not only added a right click … Continue reading

Gantt Chart of SQL Jobs

Recently, the need to map out SQL Jobs and their times has become more important to me. I needed a listing of SQL Jobs the scheduled times, and their duration, with the status. While our in house management tool provided the information I wanted an easier and more friendly tool to view these through, so … Continue reading

Reporting Services 2005/2008 Job Lookup

Ever needed to manually run a report from Reporting Services, following the rules of a subscription, but don’t want to go through the effort of editing an existing subscription, letting it run, then editing it back or creating a new one? The following T-SQL Statement, when ran against the Reporting Services Database will allow you … Continue reading