I have a script which needs to run 24/7 to collect data from another source continuously. I have created the script successfully and I start the script from a FM client and it runs perfectly on the server for a day or two, but then it stops running.
My solution is to check if the script is running by a schedule script which checks the current users of the database. This has been done successfully.
This tells me if the script is running or not. If it is not running I will like to start the 24/7 script again. This is where I need help.
I have tried perform script step (since we are on the server, instead of perform script on server), but this doesn't work. The script user stays connected, but the 24/7 script does not run (or collects information). I also tried the MBS FM.RunScript, doesn't work on server (it mentions it on the description and I have tried it).