Detailed Description and Symptoms
In V9.00A there are two possibilities (different use) to install the a DB Agent/Service.
1.) Database Agent for Jobs and Events
The Database Agent for Jobs and Event is only available for a particular database type (such as MS SQL )which can be specified in the Agent's INI file. A separate Agent must be installed for each database type that should be accessed by using Jobs or Events. The names of the database, Server etc. must be determined in the particular Job or Event object.
With this kind of DB Agent you can execute DB Jobs but not use this for dynamic Variables.
You'll have to start the Agent like this:
java -jar <jar file of the Agent>
java -jar ucxjsqlx.jar
2.)Database Agent (Service) for dynamic Variables
The Agent for SQL variables can access any supported database type. The particular type must be defined in the Connection object for databases that is assigned to the variables. Therefore, you must only install one Agent for variables. The database name and the connection parameters (Server name, port number etc) are also defined in the DB Connection object. Note that the Agent is configured in the Automation Engine's INI file.
The Agent is only required for Variable objects that use the source SQL. SQLI variables do not require an Agent.
This is the DB service.
You'll have to start the service like this:
java -jar <jar file of the Agent> -i<.ini File of the Automic Server> -service
java -jar ucxjsqlx.jar -iC:\uc4\server\bin\ucsrv.ini -service
For the standard DB Agent you have to use a Login Object
For DB Agent Service you have to use the Connection Object.