In CA WA Agent for MS-SQL (MS-SQL plugin), if the Windows domain authentication is used then user and password may be set at the manager/scheduler side. A default user with password may also be set in the properties file (target_database.properties).
Jobs may fail if the password has expired.
Release : 11.5
Component : CA WORKLOAD AUTOMATION AGENT FOR MS-SQL
As per organizational security policy, the password will have to be updated periodically. The password for user will have to be updated manually in the manager/scheduler side.