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


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

Thank you for your help
Who is Participating?
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
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
JOSHUABTAuthor Commented:
Thank you. Your script will work.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.