Report - JOBP and Task Details

[Tina Hart]

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

[Pete Wirfs]

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

[Alain Moisy]

All the modifications and current values of the variables used during execution are indicated in the ACT report. This is what you are looking for.

You can use a PREP_PROCESS_REPORT(,ACT, ......)  command in the post-processing to read the report and generate a more readable list and send it by email i.e. if you want.

You can apply this to the workflow (need a script object at end of the workflow to read the ACT report of the workflow) and/or in the post-processing of the Jobs in the workflow. So you can have a list of all values of the variables used at the execution of the workflow and inside objects.

Alain

[Tina Hart]

Thanks for the info!  I'll give this a try today!

[Phil Frankford]

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
;