Solved

How to view all report schedules in MS SQL 2005 Reporting Service

Posted on 2011-09-16
2
349 Views
Last Modified: 2012-05-12
Hello,

Is there a way to view all report schedules at a glance in MS SQL 2005 Reporting Service?

Thank you for your help
0
Comment
Question by:JOSHUABT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 36553074
Select distinct c.ItemID , c.Name AS TheReport , Schedule.* From
      dbo.ReportSchedule Inner Join dbo.Schedule
      ON dbo.ReportSchedule.ScheduleID = dbo.Schedule.ScheduleID
      Inner Join [Catalog] c
      ON dbo.ReportSchedule.ReportID= c.ItemID
0
 

Author Closing Comment

by:JOSHUABT
ID: 36563017
Thank you. Your script will work.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question