I am wanting to run a stored prcedure with no inputs / outputs on a 1 minute period starting at a specific number of seconds of each minute. The stored procedure is doing some intense house keeping tasks, and I actually have 5 different ones, so I start them at different numbers of seconds to equalize the load on the CPU.
I created an expression action item with this:
and set the Result Datatype to Boolean (also tried int).
I am using a Stored Procedure group with an update rate of 1 sec, and the trigger settings are set to look at the action item and “only execute group once when trigger is active”.
However, when I start the group, the value field always says “Bad-Unknown” and the Status tab just shows 1/1/0001… as the last attempted execution and the last successful execution.
What am I doing wrong?