AnsweredAssumed Answered

Getting a value from job report to populate variable

Question asked by ChristineBauder603411 on May 26, 2018
Latest reply on Jun 7, 2018 by ChristineBauder603411

I need to get a value (Batch Number = ??) out of the automic job report and have that value populate a variable where such variable can then be called in the next job as an input value for a modified run control to automatically update a peoplesoft run control. I've figured out the peoplesoft piece, but I need help with automic scripting to get the value. The value of the "Batch Number" does not grow by any certain increment, it will be a different number each run. 

 

This is what the report looks like. The Batch Number value is what I need - in this instance it would be 55:

 

psae -CT ORACLE -CD ICSSTG -CO "PRDSVSYS" -CP OPRPSWD -R SFD_ARCHIVE_CUCALMSG -I 59540425 -AI PSARCHIVE -OT 6 -FP "/opt/pscfg/icsstg/appserv/prcs/icsstg/log_output/AE_PSARCHIVE_59540425/" -OF 14
Normal end, status=9, retcode=0, sessionid=24235
started: 2018-05-26-11.55.06.460958, ended: 2018-05-26-12.24.32.675895
2018-05-26-11.55.06.531236: Begin PSARCHIVE
2018-05-26-11.55.06.993631: Archive ID = CUCALMSG, Archive Process = S, Batch Number = 55, Query = U8_ARC_CALC_MESSAGE, Audit Row = , Restart = N
2018-05-26-11.55.08.631348: Processing CALC_MESSAGES

Outcomes