On the general tab of a job there is a field called Location. Is there a way to pull a report on this?
Unfortunately, Applications Manager does not have an available report for this information. The value in the location field is not stored in the database but a view that contains a wrap procedure which builds the file path based on the Program Type and Library.
The SO_JOB_TABLE, which stores all Job information does have the columns SO_LIBRARY and SO_PROGRAM. These can be used and matched with the Library Path in the SO_APPLICATIONS table to build a full path if a DBA or someone with sql knowledge is able to write a sql to query these 2 tables.
I created this in a datatype to echo the program to the authoriz.lis file without having to log into the server.
You may need to modify unix with windows in the select, or whatever other OS you need.
Hope it helps.
select a.so_module as Job, a.so_library as Library, b.so_library_path_unix || c.unix_path || concat ('/', a.so_program) as PATHfrom so_job_table aLeft join so_libraries bon (a.so_library = b.so_library)left join am_program_types con (a.so_command_type = c.program_type)where a.so_library is not null
Was the information provided by maoph01 & DDeSalvo help in answering your question (if so please help us by using the "mark correct" button on the comment).Thanks,Luu
Retrieving data ...