The agent uses two properties files to communicate with a SQL Server instance: a system properties file and a target server database properties file.
A system properties file, sqlagent.properties, defines default properties for configuring the JDBC connection and filtering the fields displayed in the job spool file.
A target server database properties file, target_database.properties, defines the database URL and user credentials that the agent uses to create a JDBC connection to a SQL Server instance. During the installation, a target_database.properties file is created based on the database connection information you provide. After installation, you can create additional target_database.properties files to connect to other instances. The target_database.properties file can also contain optional properties to override properties specified in the system properties file. A property in the target_database.properties file overrides a property with the same name in the sqlagent.properties file.
The properties files are located in the config\sql subdirectory of the agent installation directory after you install CA WA Agent for Microsoft SQL Server.
|
Copyright © 2013 CA.
All rights reserved.
|
|