AnsweredAssumed Answered

Database-Defined Perform Script on Server

Question asked by SethRedlus on Jul 13, 2018
Latest reply on Jul 14, 2018 by PeterDoern

Not sure how best to ask this, and not having much luck finding it. What I'm hoping to do is to be able to set within a database a date/time to run a PSOS, and then to have it run at that time. Anyone have any clever ways to do this? The only way I can think of to do it I fear could cause too much load on the server, i.e.

 

1) Create a field to define a timestamp for when the script should run.

2) Create the script that I want to run

3) Create a scheduled script that runs every 1-minute looking to see if it find the time as specified in #1 above, and then to run the script in #2 if it does find that now is the right time.

 

Appreciate any thoughts or insights anyone might have... was kinda hoping someone might have a plugin to do this...

Outcomes