search cancel

SQL Job : Parentheses don't match error

book

Article ID: 112079

calendar_today

Updated On:

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".
 

Cause

The SQL statement in the SQL command field is missing parentheses

Environment

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

Resolution

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