Automic Workload Automation

  • 1.  How to set multiple breakpoints at once?

    Posted Dec 09, 2018 03:11 AM

    Hi all,

    how can I set multiple breakpoints at once in a running workflow? Is that even possible?

     

    We are using the Java GUI on Version 11.2.



  • 2.  Re: How to set multiple breakpoints at once?

    Posted Dec 10, 2018 07:13 PM

    This might not be what you are looking for.  But someone posted a cool trick here that I replicated on my systems.  It consists of a script object that if executed as the first task of your workflow, will dynamically turn on the breakpoint setting for all of the steps in your active workflow.  

     

    It consists of a SCRIPT object and a SQLI_SEC variable.

     

    !Get Parent RUNID
    :PSET &WORKFLOW_RUNID# = GET_PARENT_NR(&$RUNID#)
    :SET &HND# = PREP_PROCESS_VAR(name.of.SQLI.object.goes.here)
    !STOP Workflow
    :SET &RET# = MODIFY_TASK(&WORKFLOW_RUNID#, STOP_MODIFY)
    !SET Breakpoints on every Task
    :PROCESS &HND#
    : SET &TASK_NAME# = GET_PROCESS_LINE(&HND#,2)
    : SET &TASK_RUNID# = GET_PROCESS_LINE(&HND#,3)
    : SET &TASK_TASKNUM# = GET_PROCESS_LINE(&HND#,4)
    : SET &RET# = MODIFY_TASK(&WORKFLOW_RUNID#,,&TASK_TASKNUM#, BREAKPOINT, "YES")
    : print "RET=&RET#. Setting breakpoint for &TASK_TASKNUM#:&TASK_RUNID#:&TASK_NAME#"
    :ENDPROCESS
    !COMMIT Changes & Start Workflow
    :SET &RET# = MODIFY_TASK(&WORKFLOW_RUNID#, COMMIT)
    :SET &RET# = MODIFY_TASK(&WORKFLOW_RUNID#, GO, FORCED)

     

    SQL for the SQLI_SEC object; (You must bind paramter #1 to &WORKFLOW_RUNID#)

     

    select
    ejpp_object as child_task_name,
    ejpp_taskidnr as child_task_runid,
    ejpp_lnr as tasknum
    from ejpp
    where EJPP_AH_IDNR = ?
    and ejpp_taskidnr <> 0
    order by ejpp_lnr



  • 3.  Re: How to set multiple breakpoints at once?

    Posted Dec 11, 2018 10:16 AM

    Hey there. Thanks a lot for the script. This is  something, that looks more complicated than I expected. But I will give this a try. 

     

    Additionally I just saw in the manual that I can set multiple breakpoints at once in the activity monitor. How cool is that?!  I guess I need to RTFM lol.