Sending A Scheduled Report Using A SQL Query

If you have access to the SQL Repository database, you can run a schedule by running the following query:

update XL3ScheduleUpdate
  set dtUpdated = GetDate()

update XL3Schedules
  set dtNextRunTime = GetDate()
  where cName = 'My Query'

The query can be modified to run based on the schedule's uniqueid or some other criteria, if desired.

Anonymous