SQL job truncates result.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

A SQL job truncates the result of a select statement.

Report:

Running the same select statement through i.e. Management Studio returns the following output:

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Configuration.

Resolution

Change the value for 'Maximum characters in column' inside the SQL job --> Tab SQL --> Result Table Settings to a higher value:

Now the SQL job returns the same result as the Management Studio.