Deploying the JAMS Database in Azure SQL


In JAMS V6.5.54 and higher, the JAMS Database may be deployed in Azure as a Platform as a Service (PaaS) database, also known as Database as a Service (DBaas).

While installing JAMS entirely on a single Azure Server is a nearly identical process to the on-premises JAMS installation, hosting the JAMS Database in an Azure SQL Database with a local server for the JAMS Scheduler requires some small changes to the installation and configuration process.


In this topic


Back to Top

Configuring the Azure SQL Server

Before starting the JAMS Installation, configure or select an Azure Server for the Database.

  1. Configure or select a server for the database. Record the Server name, Server admin login, and Password set here, as they are used in the JAMS database deployment script and must be used to create a JAMS User. 
    NOTE: The full server name URL will be referenced as "ServerName"
  2. Navigate to the Firewall settings and ensure the JAMS Scheduler Server has access to the Azure SQL Server.
    NOTE: If necessary, create Rules to allow communication between the JAMS Scheduler Server and the Azure Server.


NOTE: Do NOT attempt to use a Database Source in Azure.


Back to Top


Installing JAMS with a Database on Azure SQL is very similar to a normal JAMS installation, except that the Database Creation Wizard must be cancelled.

  1. Access the machine where the JAMS Scheduler should be installed.
    NOTE: If JAMS was already installed on this machine, delete the Common.config file, located at C:\Program Files\MVPSI\JAMS\Scheduler\Common.config by default.
  2. Download the JAMS Installer.
    NOTE: JAMS V6.5.54 or higher is required.
  3. Run the JAMS Installer as an Administrator. The JAMS Installation Wizard will appear. Use the wizard to walk through the installation.
    • This installation requires only the JAMS Client and JAMS Scheduler components.
    • If prompted, install MSMQ. Prompts to install SQL Express can be ignored, as Azure SQL Server will be used.
  4. With the Installer Wizard steps complete, click Finish to begin the installing JAMS Components.
  5. Partway through the installation, the Create a JAMS Database dialog will appear. Click Cancel on this dialog.
  6. Confirm the cancellation.
  7. The JAMS installer will continue installing JAMS. When the JAMS installation is complete, Close the JAMS Installer. 


Back to Top

Deploying the JAMS Database

NOTE: The Azure Database creation script requires the SQL PowerShell Module. It may be necessary to install or import SQL PowerShell before running the CreateAzureDatabase script.

  1. Open the CreateAzureDatabase.ps1 script, located at C:\Program Files\MVPSI\JAMS\Scheduler\DbDeploy\CreateAzureDatabase.ps1 by default. 
  2. Edit the first 4 lines of the script to correspond with Azure SQL.
    DatabaseName - This will be the name of the Azure SQL Database.
    SQLServername - Enter the URL of the Azure SQL Server previously created.
    SQLUserName - The Server admin login of the Azure SQL Server created for the JAMS Database.
    SQLPassword - The password for the administrator of the Azure SQL Server.
  3. Save and Close CreateAzureDatabase.ps1.
  4. Run PowerShell or PowerShell ISE as an administrator.
  5. Execute the newly edited CreateAzureDatabase.ps1 script.
  6. Wait for the script to complete successfully.
  7. If any errors were encountered, open DBUpdate.log for more information. This file is located at C:\Program Files\MVPSI\JAMS\Scheduler\DBUpdate.log by default. 
  8. Users may also access their SQL Database with SSMS to view the newly created JAMS Database.
  9. Close PowerShell.


Back to Top

Loading the JAMS Sample Jobs

With the Database Installed, ensure the JAMS Sample Jobs are created.

  1. Open Task Manager on the Scheduler Server, then stop any JAMS Processes. JAMS processes include JAMSServer, JAMSScheduler, JAMSExecutor, and JAMSAgent.
  2. Open the JAMSDBA.exe utility as an administrator. This utility is located at C:\Program Files\MVPSI\JAMS\Scheduler\JAMSDBA.exe by default.
  3. Type in and run the LOAD /INSTALL command.
  4. Wait until the command is done executing, then close the JAMSDBA utility.
    NOTE: The JAMSDBA> prompt will appear on the second line when the command is done executing.
  5. Open the Windows Services, then Restart all JAMS Services.


Back to Top

Creating Folders for JAMS temporary files

Create the Temporary File Folders JAMS requires to run Jobs and save logs.

  1. Within C:\Program Data, create a directory named JAMS.
  2. Within the newly created JAMS directory, create a folder named Logs and a folder named Temp.


Back to Top

Additional Reading

Have more questions? Submit a request