I have a workflow that runs two consecutive FE workflows wherein the job in the workflow loops through a static variable with a list of our locations in it.
In the job in each FE workflow, the job does a PREP_PROCESS_REPORT for string "no records found" and if it finds it, it changes the return code to '99'.
On the Postconditions tab on the job in the FE workflow, if the retcode is "99", then it's supposed to execute a CALL object (which sends an email with the report attached) then sets the return code to '0' and carries on.
While the workflow is carrying on, it is only sending the alert on the first time that it loops through and finds "no records found". Subsequent runs are not sending the email alert.
Has anyone else seen this? If so, how did you solve for it?