How to report job output blobs from an Oracle AutoSys database.

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

The autorep command does not include an option to report job output blobs in the database. However, Oracle SQL*Plus can be used to create a report of all job output blobs directly from the AutoSys database.

Environment

Release:
Component: ATSYS

Resolution

Login to the AutoSys Oracle database as the 'mdbadmin' user using SQL*plus.

Execute the following query:
select b.job_name, utl_raw.cast_to_varchar2(dbms_lob.substr(data)) from ujo_jobblob a, ujo_job b where a.joid=b.joid;

Example:
Job 'test_blob' was defined to run an 'autoflags -a' command and the 'std_out_file' attribute set to $$blobt. This redirects the output of the autoflags command to a job output blob in the AutoSys database.

Using SQL*Plus, the above query produces the following result:
SQL> select b.job_name, utl_raw.cast_to_varchar2(dbms_lob.substr(data)) from mdbadmin.ujo_jobblob a, mdbadmin.ujo_job b where a.joid=b.joid;

JOB_NAME
----------------------------------------------------------------------------
UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(DATA))
----------------------------------------------------------------------------
test_blob
INC2 SOLAR ANY 11.0 SP2 83f91461 USPLEJMSUN1