Difference between revisions of "Sending A Scheduled Report Using A SQL Query"

(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...")
 
m (Text replacement - "XLCubed" to "FluenceXL")
 
Line 12: Line 12:
 
==Further Reading==
 
==Further Reading==
 
* [[Sending A Scheduled Report Using Integration Services]]
 
* [[Sending A Scheduled Report Using Integration Services]]
* [[Scheduling with the SQL Repository|XLCubed Scheduling with the SQL Repository]]
+
* [[Scheduling with the SQL Repository|FluenceXL Scheduling with the SQL Repository]]
  
 
[[Category:Scheduling]]
 
[[Category:Scheduling]]
 
[[Category:Development]]
 
[[Category:Development]]

Latest revision as of 09:39, 4 July 2023

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