Is there a query i can run which will show me all the scheduled reports in sql server reporting services 2000?
I've logged onto the server via the web interface, but the information displayed in the shared schedules doesn't seem to match up.
For example there's one shared schedule for 3:30pm every weekday and when i look at what reports are assigned to that schedule, and then actually go to that report, in the subscription tab is actually says the report is scheduled for 3:20, not 3:30
Plus i assume if the report is not using a shared schedule, it wont show up on that page at all.
I tried selecting from the schedule table, but it looks like that's just the shared schedules.
So is there any way for me to get a listing of ALL the scheduled reports that are set to run today or the next few days?
View Complete Post