HCL Workload Automation, Version 9.4

Running scripts to create or upgrade the SQL schema on Microsoft SQL Server

This section describes the command that you run to create or upgrade the SQL schema on Microsoft SQL Server. The command that you run depends on the task you are doing and on the type of authentication that you use to connect to the SQL Server.
Creating the SQL schema before installing the product
When using SQL Server Authentication
Master domain manager and its backup
  1. Run Procedure to create the HCL Workload Automation SQL schema on Microsoft SQL Server when using SQL Server Authentication
  2. Run Procedure to create the dynamic workload broker SQL schema on Microsoft SQL Server when using SQL Server Authentication
Dynamic domain manager and its backup
Run Procedure to create the dynamic workload broker SQL schema on Microsoft SQL Server when using SQL Server Authentication.
When using Windows Authentication
Master domain manager and its backup
  1. Run Procedure to create the HCL Workload Automation SQL schema on Microsoft SQL Server when using Windows Authentication
  2. Run Procedure to create the dynamic workload broker SQL schema on Microsoft SQL Server when using Windows Authentication.
Dynamic domain manager and its backup
Run Procedure to create the dynamic workload broker SQL schema on Microsoft SQL Server when using Windows Authentication.
Upgrading the SQL schema before upgrading the product
When using SQL Server Authentication
Master domain manager and its backup
  1. Run Procedure to upgrade the HCL Workload Automation SQL schema on Microsoft SQL Server when using SQL Server Authentication
  2. Run Procedure to upgrade the dynamic workload broker SQL schema on Microsoft SQL Server when using SQL Server Authentication
Dynamic domain manager and its backup
Run Procedure to upgrade the dynamic workload broker SQL schema on Microsoft SQL Server when using SQL Server Authentication.
When using Windows Authentication
Master domain manager and its backup
  1. Run Procedure to upgrade the HCL Workload Automation SQL schema on Microsoft SQL Server when using Windows Authentication
  2. Run Procedure to upgrade the dynamic workload broker SQL schema on Microsoft SQL Server when using Windows Authentication.
Dynamic domain manager and its backup
Run Procedure to upgrade the dynamic workload broker SQL schema on Microsoft SQL Server when using Windows Authentication.