Automic Retention_Time for the SQL Agent
Article ID: 138540
Updated On:
Products
CA Automic Workload Automation - Automation Engine
CA Automic One Automation
Issue/Introduction
What does the setting of 0 for retention_time for the SQL Agent do within Automic?
Resolution
If the parameter "retention_time" is set to 0, this disables the re-use of already established database connections, and the connection is terminated immediately after completion.
Since creating a database connection is a quite expensive task, we do recommend setting this not to 0, unless really needed.
Feedback
Yes
No
Powered by
