Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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.

    Further Reading