AnsweredAssumed Answered

Get variable values in tasks (JOBS) from GENERATE_SCRIPT_VARS in parent workflow (JOBP)

Question asked by MyleneChalut629840 on Mar 19, 2019
Latest reply on Apr 1, 2019 by MyleneChalut629840

Hi guys!!

 

 

I created the following JOBI to read my VARA:

 

 

:SET &job_env#= 'BRAPPSRVDEV'

 

! Setting variables for Project and Environment from VARA

 

:   SET &RET# = GENERATE_SCRIPT_VARS("VARA.BR.&job_env#", APPEND_POUND_SIGN, UPDATE)

:   PRINT ' ApplicationErrorThreshold = &ApplicationErrorThreshold# '

:   PRINT ' BRSecurityCheckDivisionChange = &BRSecurityCheckDivisionChange#'

:   PRINT ' DUExternalApplications = &DUExternalApplications#'

:   PRINT ' DUExternalScripts = &DUExternalScripts#'

:   PRINT ' DULogPathName = &DULogPathName#'

:   PRINT ' MessagesOlderInMonths = &MessagesOlderInMonths#'

:   PRINT ' PROCESSENVIRONMENT = &PROCESSENVIRONMENT#'

:   PRINT ' SQLTimeOutErrorThreshold = &SQLTimeOutErrorThreshold#'

 

!: Setting time variables

:   SET &MONTHFORMAT# = "MM"

:   SET &MONTH# = SYS_DATE(&MONTHFORMAT#)

:   SET &YEARFORMAT# = "YYYY"

:   SET &YEAR# = SYS_DATE(&YEARFORMAT#)

:   SET &REFERENCEPERIOD# = &YEAR#&MONTH#

:   PRINT "ReferencePeriod: &REFERENCEPERIOD#"

 

 

I have added the include in the Process tab of my JOBP:

 

:INC JOBI.BR.GET_BRAPPSRVDEV_VARIABLES

 

I have 2 JOBS in the workflow.  Both of them have been setup with "All Variables Inherit from Parent" under their Variables tab.

 

I can see that the include is working in the ACT report, but they are not being passed to the JOBS.  Can somebody tell me what the problem is?

 

We are using version 12.2 and the setup to use function GENERATE_SCRIPT_VARS has been done. (=Y)

 

Thanks in advance for your help :-)
Mylene

Outcomes