spool file for sql job type

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

Issue:

On page 11 of WA_Agent_for_Databases_Release_r11_3_4_ENU.pdf, it suggests not using the destination keyword.  If I do use a destination file, I get what I expect and I get a file in Program Files (x86)\CA\Workload Automation AE\SystemAgent\WA_AGENT\spool\SB3_SCH\MAIN\WAAE_WF0.1.  If I don't use a destination keyword, I don't get anything in the spool directory, and I see 'Error: E139011 Agent error response: [File is not available]' in the WCC under job runs when trying to access the spool file. Is this broken?

 

Environment:

Workload Automation AE 11.3.x

Workload Automation Agent for Databases 11.3.4

Workload Control Center 11.3.x, 11.4.x

 

Resolution:

If you specify a destination_file for a sql job type the output will be saved there. If you leave off that setting the information is written to the spool file as part of the job logs. By default the job logs and spool files are deleted upon successful completion of the job. As a result the output of the sql job would be removed if the job ran to SUCCESS. 

In that case the behavior seen in WCC would be accurate.  As the spool file would not exist, it was removed when the job ran to SUCCESS.

The agent does have settings which could disable the automatic cleanup of the spool files upon successful job completion.

WARNING - If they are disabled there will be a build up files in the spool directory. Multiple files for each job run.  It would be up to the user or administrator to maintain the files and directories so that disk space is not exhausted. 

The settings are 

agent.spool.success.autocleanup 

oscomponent.joblog.success.autocleanup 

runnerplugin.spool.clean.enable 

 

Additional Information:

You can read more about the settings in the System Agent implementation guide.