I spoke to a developer and I was told that this isn't possible. I just wanted to confirm with others if that is really the case.
So I have a custom record where I am supposed to select the schedule of when the related M/R would run. I was told that it's not possible to use that schedule in the custom record to trigger an M/R script. That the schedules should just be defined in the script deployment records. The small issue is that the users who define the schedule are non-admin users at the moment, so we may need to give them SuiteScripts permission which is not ideal unless we transfer the responsibility to an admin.
t
Timothy Wong
05/24/2024, 3:17 PM
I suppose your solution is a custom record with some datetime field and have a scheduled deployment with the getinputdata looking up some before current time mechanism..
This setup is possible but I think you'd need to consider firstly the scripts will have a delta time with the actual running time because you'll only schedule every 15 mins
If you decide to make it more frequent then there is duplication problems if the scripts end up running concurrently so you ought to also avoid that too
You should also consider how long each batch runs, anything sharply less than your scheduled deployed run, this custom record approach should work
Also make sure you take into time of the timezone if its an mnc~
l
Luis
05/24/2024, 4:42 PM
Thank you. Hmmm so what's the high level approach here? There is an MR script that will check the custom records to see if there is one that is already running? If it finds one that is due, the MR will continue executing the rest of the script?
Luis
05/24/2024, 4:44 PM
Actually, on the custom record, it's not a date/time all the time. But more of the frequency. For example, hourly, every 15 mins, etc.
e
Eric B
05/24/2024, 7:14 PM
Custom record with a scheduled script checking to see if there is work to be done as well as logic to check if the MR script deployment is already running and an update function to mark the custom record's status.