:SET &RET# = ACTIVATE_UC_OBJECT(JOBS.UNIX.MOVE.SQL.REPORT)
And the UNIX job from above (here called JOBS.UNIX.MOVE.SQL.REPORT) would run on the same machine as the SQL job and would have the following in the Process tab:
!Get Run Number for activating job
:SET &ACT_RUNNR # = SYS_ACT_PARENT_NR (ACT)
!Get Agent for activating job
: SET &ACT_HOST # = GET_STATISTIC_DETAIL (&ACT_RUNNR #, DST_HOST)
!Get Path where job reports are stored on Agent that activated job
:SET &FILE_PATH# = GET_VAR(UC_EX_PATH_JOBREPORT, &ACT_HOST#)
:P "UC_EX_PATH_JOBREPORT = &FILE_PATH#"
!Get Alpha value of run number for activating job
:SET &RUNNRALPHA# = RUNNR2ALPHA(&ACT_RUNNR#)
:P "ALPHA Value of Run Number &ACT_RUNNR# is &RUNNRALPHA#"
:P "Report can be found on &ACT_HOST# machine at:"
:P "&FILE_PATH#O&RUNNRALPHA#.TXT"
!Set NEW_PATH and NEW_FILE – path for new file, and name for New file
:SET &NEW_PATH # = "/u01/users/uc4/test"
:SET &NEW_FILE # = "&ACT_RUNNR#_SQL_REPORT.TXT"
!Copy file to new location
cp &FILE_PATH#O&RUNNRALPHA#.TXT &NEW_PATH#/&NEW_FILE#
For Filetransfers, the command below would be used to set the source file attribute from the Process tab:
:PUT_ATT FT_SRC_FILE = "&FILE_PATH#O&RUNNRALPHA#.TXT"