SQL Job : Parentheses don't match error

Document ID : KB000112079
Last Modified Date : 24/08/2018
Show Technical Document Details
Issue:
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.