December 2008 Blog Posts

Managing Reporting Services Subscriptions

Reporting Services offers two "out of the box" methods to manage subscriptions (subscriptions are scheduled report executions, controlled by Reporting Services): Each report has a "Subscriptions" tab (depending on permissions) which shows your/all subscriptions (again, depending on permissions) for that report only All your subscriptions can be managed using the "My Subscriptions" link in the top right-hand corner of Report Manager There's one key thing missing from the two methods: how does an administrator or power user manage all subscriptions in Reporting Services? The Query I'm going to provide a starting point for a better way...

posted @ Monday, December 08, 2008 1:37 PM | Feedback (0)

SQL Server Agent Job E-Mail Notification Query

I'm about to have a couple of weeks holiday over Christmas (lucky me!) and one of the tasks my boss asked me to do before I went was make sure that e-mail notifications that were directed to me only, should be re-assigned to our entire team. We rely on SQL Server Agent Jobs and these can be set to notify operators when the job fails, succeeds, or completes (regardless of the outcome). After quickly looking through a couple of jobs, I found plenty that were only notifying me (oops). I needed a more foolproof way to identify the jobs that needed...

posted @ Tuesday, December 02, 2008 1:45 PM | Feedback (2)

«December»
SunMonTueWedThuFriSat
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Subscribe

Recent Posts on Thomas Williams Tech Blog
Recent Posts on my personal blog, Thomas Williams.blog

About
Archives
Post Categories
Syndication:

RSS