Automic Workload Automation

Expand all | Collapse all

Is there a query that can tell if an object is unblocked?

Michael Pirson

Michael PirsonOct 31, 2018 02:19 PMBest Answer

Larry Halseth

Larry HalsethOct 31, 2018 02:26 PM

  • 1.  Is there a query that can tell if an object is unblocked?

    Posted Oct 31, 2018 11:29 AM

    I know we can query a parent job plan and see unblocked objects within, but without run ids of the unblocked objects.

     

    select EJPP_Object, EJPP_Status, EJPP_JobStatus from EJPP where
    EJPP_AH_Idnr = ?

     

    Is there a way to query for a run id and see if that object is unblocked? I assume I'm missing something in the schema somewhere.



  • 2.  Re: Is there a query that can tell if an object is unblocked?
    Best Answer

    Posted Oct 31, 2018 02:19 PM

    Think you are looking for EJPP_TASKIDNR



  • 3.  Re: Is there a query that can tell if an object is unblocked?

    Posted Oct 31, 2018 02:26 PM

    Perfect, thanks!