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| | + | * [[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.