SQL Server job fails with the following information:
Agent Status Long: "Possible SQL injection detected in Table Validation UPDATE - PRD"
Agent Status: "Failed to get PS job data."
Release : 11.5
Component : CA Workload Automation Agent for SQL Server
Due to a code change designed to prevent SQL injection from occurring. Data that contains the following words corresponding to SQL keywords will be rejected: SELECT, INSERT, UPDATE, DROP, RENAME, CREATE, DELETE, GRANT, REVOKE, and WHERE.
When using these keywords in email subject with SQL jobs, shorten the keywords. Perhaps something like the following will suffice:
UPD for UPDATE
INS for INSERT
DR for DROP
REN for RENAME
CRE for CREATE
DEL for DELETE
GRA for GRANT
REV for REVOKE