Automic Workload Automation

Expand all | Collapse all

I need to have a List of Job Plan Name with Task Names, Task Number & the given Alias Name

Jump to Best Answer
  • 1.  I need to have a List of Job Plan Name with Task Names, Task Number & the given Alias Name

    Posted 10-30-2019 09:52 PM
    Edited by Prosenjit Maji 10-30-2019 10:32 PM
    Hello Folks,

    We are using AE V12.2.2. I need some help to fetch a List of Job Plan Name with Task Names, Task Number & the given Alias Name in the task property inside job plan.

    ------------------------------
    Regards,
    Prosenjit
    ------------------------------


  • 2.  RE: I need to have a List of Job Plan Name with Task Names, Task Number & the given Alias Name

    Posted 11-15-2019 10:01 AM
    Any guidance on SQL query please ?

    ------------------------------
    Regards,
    Prosenjit
    ------------------------------



  • 3.  RE: I need to have a List of Job Plan Name with Task Names, Task Number & the given Alias Name

    Posted 11-15-2019 10:35 AM


    I took one of ours that when proving the schedule name(s), it will provide a list of all triggered objects, which will also return all child objects along with the calendar entry.  I add the alias which seems to work.

    There might be better queries, but this does work, but not the prettiest.

    select OH.OH_Name as 'Schedule Name', JPP.JPP_Object as 'Parent Name', J.JPP_OType as 'Object Type', j.jpp_alias as Alias,
    JPP.JPP_ErlstStTime as 'Start Time', J.JPP_Object as 'Child Name', JPPC.JPPC_CaleKeyName as 'Calendar Keyword'
    from OH
    full join JPP on OH.OH_idnr = JPP.JPP_OH_idnr
    
    full join OH P ON JPP.JPP_Object = P.OH_Name
    and OH.OH_Client = p.OH_Client
    
    full join JPP J ON P.OH_Idnr = J.JPP_OH_Idnr
    
    full join JPPC on OH.OH_Idnr = JPPC.JPPC_OH_idnr
    and JPP.JPP_Lnr = JPPC.JPPC_JPP_Lnr
    
    where OH.OH_Name in ('schedule name1','schedule name2')
    and OH.OH_Client = 12 
    
    and J.JPP_Object != 'START' and J.JPP_Object != 'END'
    order by 'Parent Name'
    ​




  • 4.  RE: I need to have a List of Job Plan Name with Task Names, Task Number & the given Alias Name
    Best Answer

    Posted 11-15-2019 10:48 AM
    Hi

    as a start you can use this one:

    adjust Client 1234 to your needs

    select OH_Name as "Workflow Name", jpp_object as "Task Name", jpp_otype as "OBJ typep", JPP_ALIAS as "Alias", jpp_lnr as "Object No in Workflow", jpp_otype from OH
    join JPP
    on JPP_Oh_IDNR=OH_IDNR
    where oh_client=1234
    and oh_deleteflag=0
    order by OH_Name, jpp_lnr

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