SQL Job : Parentheses don't match error

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

Attempts to define a database SQL job is failing with error "Parentheses don't match error".
 

Environment

CA Workload Automation DE (dSeries)
CA Workload Automation Desktop Client

Cause

The SQL statement in the SQL command field is missing parentheses

Resolution

Check the SQL statement for missing parentheses, added the parentheses in the SQL statement.