Query ReportServerDB,Table ReportSchedule, Column ReportAction -> Translation needed
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
October 28th, 2012 11:01am

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)
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2012 11:31am

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
October 28th, 2012 11:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics