does anyone analyzed already the integer column "reportaction" in Table ReportSchedule? Search engine returned nothing for me... Here's my translation so far, but i'm missing the integers 1 and 2: SELECT ScheduleID ,ReportID ,SubscriptionID ,ReportAction ,ReportActionName = CASE rs.ReportAction WHEN 4 THEN 'Subscription' -- represents either datadriven oder user-rcreated subscription WHEN 3 THEN 'CacheInvalidate' --represents either report or shared-dataset cache retire schedule ELSE CAST(ReportAction as nvarchar(100)) END FROM ReportServer.dbo.ReportSchedule RS

1: Update Cache (http://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/Schema15/ReportServer/Programmability/Stored_Procedures/GetCacheSchedule.html) 2: Create Snapshot (http://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/Schema15/ReportServer/Programmability/Stored_Procedures/GetSnapShotSchedule.html) 3: Invalidate Cache (http://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/Schema15/ReportServer/Programmability/Stored_Procedures/GetCacheSchedule.html) 4: Subscription? (based on your findings above)

thanks, great! so we end up with: 1 == UpdateCache 2 == create snapshot 3 == Invalidate cache --represents either report or shared-dataset cache retire schedule 4 == Subsciprition -- represents either datadriven oder user-rcreated? subscription