I'm trying to write a report showing all report subscriptions etc being run by SQL agent jobs. Looks like I can get the information I require from the ReportSchedule table in the report$server database. However, I seem to be getting multiple entries and I seem to be getting snapshots mixed in with subscriptions. An identifier seems to be the ReportAction field or Type in the Catalog table. I'm unsure though of the definition of these two fields. Where can I get a field layout and description of report server database tables please? Would have thought this would have been easy to find on the web somewhere or on the microsoft site but I've failed dismally!