AppWorx, Dollar Universe and Sysload Community

 View Only
  • 1.  UC4 9.1.3 dependency question

    Posted Oct 02, 2019 03:32 PM
    We have a process flow that has a test condition of, timing=before, condition=current time, If time >20:30, then WAIT UNTIL MET, action timing is- first time the condition is true. When the job runs past midnight due to predecessors not finishing the job doesn't run because it's looking to run @ 20:30 the next day. Is there a lookback feature or some way to fix this? We now have to run it manually.​

    ------------------------------
    Scheduling Consultant
    South Jersey Industries
    GA
    ------------------------------


  • 2.  RE: UC4 9.1.3 dependency question
    Best Answer

    Posted Oct 11, 2019 11:15 AM
    Hi Chris,

    I wonder if you could set the process flow to write to a subvar the date the flow started and then create another subvar for your condition that would use a SQL case statement to compare against the sysdate.

    select
    case
      when trunc( sysdate ) > flow_start_date return 'Y'
      when to_char( sysdate, 'HH24MI' ) > '2030' then 'Y'
      else 'N'
    from dual