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

[PROSENJIT MAJI]

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

[PROSENJIT MAJI]

Any guidance on SQL query please ?

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

[Jared Kessans]

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

[Frank Muffke]

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