Where can I found the Autosys database connection settings in the AAI database?

Products

• Automic Automation Intelligence

Issue/Introduction

Where can I found the Autosys database connection settings in the AAI database?

Environment

Release : 6.x

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

You can find the database connection details for your Autosys schedulers in the schedulerconnectionconfig column of the jobscheduler table. 

 

A query like below would get that.

select schedulername, schedulerconnectionconfig  from jobscheduler where schedulername='<SchedulerName>'

 

 

It is going to return all the database connection settings for that scheduler.

 

Here is a sample output of that column:

{"autosysHighAvailability":false,"primaryConnection":"{\"dbms\":\"Oracle\",\"userid\":\"aedbadmin\",\"password\":\"<XXXXX>",\"databaseName\":\"orclcdb\",\"server\":\"dbServerName\",\"port\":\"<port number>\",\"kerberized\":\"false\",\"timeout\":\"0\",\"customConnectionUrl\":\"false\",\"customConnectionUrlString\":\"jdbc:oracle:thin:@<host>:<port>/<service_name>\\n\\nor\\n\\njdbc:oracle:thin:@<host>:<port>:<sid>\"}","instanceName":"EN1","eemEnabled":false,"ready":true,"caseSensitive":true,"connectionSucceeded":true,"lastEventProcessedTime":"1614960784000"}