SQL Agent only ever trying to connect to one CP, does nothing during CP freeze
book
Article ID: 189355
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
SQL Agent is configured to use CP . What happens if the CP is stuck ? Will the SQL Agent try to connect next available CP ?
Environment
Release : 12.3
Component : AUTOMATION ENGINE
Resolution
Yes , SQL agent will try to connect next available CP if actual connected CP was not stuck with query of something else prevented it from closing the communication between agent and CP.