Hi, I have a requirement to run the Workflow Activity once per day until a certain date has been reached.
Once that date is reached, it will continue on the next activity.
I can't seem to find the right approach/method.
Do i use a timeout? do I Defer the activity?
The Package that is WF pertains to just uses the simple logic below
Begin
***do some stuff***
if sysdate = the_dead_line then
resultout := Wf\_Engine.eng\_completed||':'||Wf\_Engine.eng\_null;
ELSE
resultout := \*I THINK THIS IS THE PART I GET WRONG\*
END IF
END;
I've tried WF_Engine.Eng_Timedout but it runs more than expected (once a day). once the procedure finishes, it runs again, not waiting until tomorrow.
I've also tried Wf_engine.Eng_deferred and setting something like sysdate+1 but it doesn't seem to work.
I've also tried setting the Activity's Threshold above 50, then running a background engine, but it looks like it does not go out of the deferred state.
The activity looks like this.
I haven't tried retry or loop, as to i do not have an idea how to do it.
can anyone help?
thanks!