We do:
select oh_client as 'Client'
,OH_Name as 'OH_Name' /* Name of the object. */
,JPP_Lnr as JPP_Lnr
,JPP_OType as JPP_OType
,JPP_Object as JPP_Object
,JPP_ErlstStTime as 'Earliest_Start'
,JPP_LtstStTime as 'Latest_Start'
,JPP_LtstEndTime as 'Latest_End'
,JPPC_CaleName as 'Cal_Name'
,JPPC_CaleKeyName as 'Cal_Event'
,JPP_CCType as 'Cal_Cond'
,JPP_Active as Active
,JPP_ConFlag as ConFlag
from OH, JPP, JPPC
where oh_client = &$CLIENT#
and OH_OType = 'JSCH'
and JPP_OH_Idnr = OH_Idnr
and JPPC_OH_Idnr = OH_Idnr
and JPPC_JPP_Lnr = JPP_Lnr
order by JPP_ErlstStTime,JPP_Object,JPPC_CaleKeyName
;
Original Message:
Sent: 01-20-2020 10:14 AM
From: Hart
Subject: Report - JOBP and Task Details
Thanks for the info! I'll give this a try today!
Original Message:
Sent: 01-16-2020 04:24 PM
From: Pete Wirfs
Subject: Report - JOBP and Task Details
The variables that are resolved at activation time are documented on the 'ACT' report. I cobbled together this SQL to try and extract that information.
A problem with this information however, is I don't think it will tell you if a script modified one of the variable values before actual task execution.
select ah_idnr as RUNID, rt_msginsert, * from rh, rt, ah
where rh_ah_idnr = rt_ah_idnr
and ah_idnr = rh_ah_idnr
and rh_type = 'ACT' and rt_msgnr = 20206
and rh_deleteflag = 0
and ah_oh_idnr = (select oh_idnr from oh where oh_name = '<ObjectName>')
and ah_idnr = 4962179 -- SELECT BY RUNID
------------------------------
Pete
Original Message:
Sent: 01-16-2020 02:14 PM
From: Hart
Subject: Report - JOBP and Task Details
Hello,
We are using the reporting tool to gather definitions and stats, which is working as expected, however, one of our developers are looking for the variables on each task in a workflow and what their values are. I've been working with the JPP, JPOV, JPPV tables and I'm not getting the expected responses. I had a variable that I used in the past that would gather pre and post condition data which worked as expected, but unfortunately, this is not working for the Variables/Prompts tab to pull the data.
The main reason for the request is a manager wants to see which values are in the variables at the time the job is executed in the workflow.
If anyone has any ideas or examples, please let me know.
Thanks!
Tina