Get list of all manually held jobs from all workflows

[Amey .]

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 .

[Pete Wirfs]

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
------------------------------

[Amey .]

Is there anyway we can do it in Automic workload Automation GUI, so that we take action as well on the job results.

[Pete Wirfs]

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
------------------------------

[Alexander Trenker]

Hi @Amey .,

Have you tried to click on the list view?

Cheers,
Alexander
​​

[Amey .]

@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.
​

[Frank Muffke]

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.
------------------------------