Hi everyone, I have a SQL service that is working fine, except I don't want it to run on a schedule or continuously. I'd like to only run when requested. Run once and then stop until another request. Is there anyway to set up a service like that?
Where is the SQL residing and how do want to trigger it?
If it's sitting on a local Cache server you can start it any number of ways: web page, Cache routine menu, text/email a listener routine, hit a JSON service, "Alexa, start my SQL query", push a big red button, etc.
If on the cloud somewhere or on someone else's server behind a firewall you have to get past authentication/firewall to start the query.
- Tom Fitzgibbon | 9179331226 | gototomAtG...l