ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.