Application group wants batch job to terminate if it is unable to establish SQL session to external database.
Job log indicates MSGID QSQLMSG/SQ30080
"Communication error occurred during distributed database processing.
This appears in the joblog as a level 30 diagnostic message.
When this message is encountered we want the job to exceed end severity and terminate.
I have tried raising the severity code on the SQL message identifier and while it exceeds end severity for the job description attached to the active job the job does not end. i suspect this is happening because this the SQL message is received as a diagnostic not escape message.
How can I get the job to abend when this (or ther SQL specific message identifiers) are received in the active joblog?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!