Automic Workload Automation

Expand all | Collapse all

Get list of all  manually held jobs from all workflows

  • 1.  Get list of all  manually held jobs from all workflows

    Posted 07-29-2021 03:34 PM
    I am new to Automic workload automation and need help from experts on knowing how get manually Help job details in filter option.

    Requirement is we want to Get list of all  manually held jobs from all workflows.
    in above scenario when we manually held a job while its predecessor job was executing its job status is still showing as waiting for predecessor but its status shows HELD-Manual stop has been set.
    and even in monitoring tab its status is shown as waiting for Predecessor


    Which is giving us no results as when we use filters for the same -

      Please share your views on the same .


  • 2.  RE: Get list of all  manually held jobs from all workflows

    Posted 07-30-2021 02:00 PM

    Does this database query give you what you need?

    select oh_client
    , oh_name as WorkflowWithBreakpoint
    , jpp_lnr as WorkflowTaskNumber
    from jpp, oh
    where oh_idnr = jpp_oh_idnr
    and oh_deleteFlag = 0
    and oh_client = 100
    and jpp_Active in (2, 3)
    order by 1, 2, 3



    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------



  • 3.  RE: Get list of all  manually held jobs from all workflows

    Posted 07-30-2021 03:54 PM
    Is there anyway we can do it in Automic workload Automation GUI, so that we take action as well on the job results.


  • 4.  RE: Get list of all  manually held jobs from all workflows

    Posted 07-30-2021 05:12 PM
    You could put the SQL into a VARA.SQLI object and use the "preview" option to return the results within the GUI.  But the results list would not be actionable.  You would still have to cut/paste each object into the search tool in order to navigate to that object.

    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------



  • 5.  RE: Get list of all  manually held jobs from all workflows

    Broadcom Employee
    Posted 07-30-2021 07:22 PM
    Hi @Amey_10540,

    Have you tried to click on the list view?

    Cheers,
    Alexander
    ​​


  • 6.  RE: Get list of all  manually held jobs from all workflows

    Posted 08-02-2021 09:29 AM
    @aalexander - Yes We tried that , issue is that we are not getting list of jobs after using filter as there are two status we are observing for JOBS one is STATUS and Other one is JOB STATUS, I guess filter only checks for JOB STATUS and not STATUS option.



  • 7.  RE: Get list of all  manually held jobs from all workflows

    Posted 24 days ago
    Hi
    Seems like a bug in AWI (V12.3.4+HF1 reproducible)

    If you filer for manual "Stop"

    AWI returns nothing although there is one in status waiting for predecessor - manual stop has been set



    I would recommend opening a ticket @ AutomicSupport


    cheers, Wolfgang



    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------