XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Sending A Scheduled Report Using A SQL Query
Revision as of 14:45, 29 January 2018 by Antonio.remedios (talk | contribs) (Created page with "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 XL3...")
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.