AutoSys Workload Automation

Is it possible to execute jobs in a cluster of sql?
How can you configure an agent in a cluster of sql?

Hi,

Most DB cluster have a VIP (virtual IP) or front end.  When submitting jobs, point the JDBC to VIP or host.

In Oracle, users can point to SCAN, which then forwards the requests to active node.

Thank you,

Nitin Pande

CA Technologies

Hi Nitin!

if I have two windows servers and a cluster always on of sql with one listener how should I do the configuration?

--------------------------

What we want is that CAWADE can run JOBS in a Sql cluster (SQL Server 2016 Always On)

SQL Server 2016 Always on = two Windows servers
Cluster of SQL = Cluster of windows (2 nodes) and in each node there is an instance of SQL which are connected with a LISTENER

--------------------------

Hi,

The JDBC will have the URL of your cluster.  The DE simply submits requests to DB via JDBC.  The cluster will decide how and where SQL statements will be executed.  You can set the to multiSubnetFailover true, see here.

However, if there is a node failover, then DE may also failover/shutdown (in HA) if there was an update being done.  DE will not resubmit an update statement if it gets an exception.  This is to prevent any DB inconsistencies.

Thank you,

Nitin Pande

CA Technologies

hi Nittin!

how does cawade know which of the two windows servers is the active one?

I have to configure on each server a cawade agent and then join them through a agent group (random)?

each agent will be placed the sql plugin and there is configured the listener?

this is what they say?

its correct?

regards

Hi,

The Agent or DE won't know which is active.  The nodes are handled by the clustering layer.  So, the applications don't have to worry about it.  They will simply connect to the listener/front end and then it takes care of the connection to whatever node is active.

Thanks,

Nitin Pande

CA Technologies

Hi Nitin, 

I really appreciate your help.

We currently are using batches to execute our jobs, instead of  SQL Server Plugin.

Do I have to use the SQL Server Plugin to configure CAWA DE in HA?

Regards!

Hi Ayzar,

Yes, you can surely use SQL plugin to automate your jobs.

Thank you,

Nitin