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

book

Article ID: 52625

calendar_today

Updated On:

Products

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

Issue/Introduction

Description:

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.

Solution:

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

Environment

Release:
Component: ATSYS