std_out/err_file path on Autosys DB

Document ID : KB000015327
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Need absolute path of std_out/err_file path on Autosys DB without variable in jil of job.

For example #

 insert_job: XYZ  
 job_type: CMD
 command: ls
 machine: redhat-1136sp5.ca.com
 owner: root@redhat-1136sp5.ca.com
 std_out_file: "$OUTLOG"
 std_err_file: "$ERRLOG"

 

Rather than just "$OUTLOG" in table need complete path on DB.

 

Question:

Which tables stops the information of std_out/err_file in Autosys DB?

Environment:
All 11.3+ WAAE versions
Answer:

The tables which stores the information about std_out/err_file are ujo_job_run, ujo_jobst and ujo_command_job which hold the exact path along with variables in jil of job(for parameter std_out/err_file).

In case if you need complete path(resolved variable), you may have to use below query.

 

Select run_info from ujo_extended_jobrun_info where joid=(select joid form ujo_job where job_name='job_name’ and is_active=1) ;

Note # Replace job_name with the actual job name.

 

Additional Information:

In case of any issues please raise a case to support.