Getting Scheduled Activities of all WebReports

You could file an RFE to request that this be added in the future: How to ask for product help: PMRs, RFEs, and more


This will give you the raw data from a MSSQL db:

SELECT
      [ScheduledID]
      ,[UserID]
      ,[ScheduleInterval]
      ,[StartTime]
      ,[EndTime]
      ,[NextAttempt]
      ,[TypeParameters]
  FROM [BESReporting].[dbo].[SCHEDULED_ACTIVITY]
  WHERE [BESReporting].[dbo].[SCHEDULED_ACTIVITY].[IsDisabled] like 0

In order to really make sense of the results it will require much more complicated SQL:

The ReportID=14 found above in TypeParameters seems to correspond to the ID in here:

SELECT
      [ID]
      ,[ReportName]
      ,[Creator]
      ,[LastModified]
      ,[LastEditedBy]
  FROM [BESReporting].[dbo].[WEBREPORTS]

You should be aware that SQL queries could break at any time in the future.