Page History

This section guides you through the installation of SQL Enterprise Job Manager. You can install IDERA SQL Enterprise Job Manager on any computer that meets or exceeds the product requirements.

If you have not installed your IDERA Dashboard, click here to follow the respective steps. 

...

1. On the welcome window, click  Next to continue. 
2. Read the End-User Licensing Agreement and check the box I accept the terms in the License Agreement, click Next. 

3. On the Destination Folder window select where SQL Enterprise Job Manager will be installed.

   Info
   The path C:\Program Files\Idera\SQLEJM\   is displayed by default. If you want to change this path, click Change and select the folder where you want to install the product. Click Next.

4. Specify the Idera Dashboard Location where you want to install SQL Enterprise Job Manager and type the respective Administrator Credentials to access this Dashboard. 
5. Type the name with which you want to register

   Register your SQL Enterprise Job Manager instance in the IDERA Dashboard choosing a name for it.

   Info
   This name

   will be

   is used as the identifier for SQLEJM if multiple instances of the product are installed on the Dashboard.

6. Specify the Service Account

    under

   under which the IDERA SQL Enterprise Job Manager services will run

   . The Service Account should be specified in the following format: <Domain Name>\<User Name> and then type the respective Password

   and type the respective password. The installer grants the "Log on as a service" right to the account you specify.

   Click Next. Take into account

   Click Next.

   Info
   The Service Account should be specified in the following format: <Domain Name>\<User Name>. Consider that the specified account needs to be a member of the local Administrator group.

7. On the Service Ports

    section

   section, type the port that SQL Enterprise Job Manager will use for the Collection Service.

   Info
   By default,

    SQL

   SQL Enterprise Job Manager uses port 9271 for the Collection service.

    You

   You can change this value according to your requirements.

   Take into account that

   Warning
   Consider if the Firewall is enabled, it allows TCP traffic through these ports.

8. On the Repository Databases window window, select the location and name for of the repository. You have to specify Specify the SQL Server instance where this repository will be created and the name of the the EJM Database. 

9. In the same window,

   you can also

   set

   the 

   the Connection Credentials

    that

   that SQL Enterprise Job Manager

   uses

   will use to create this repository database.

   Info
   By default, the setup program uses the credentials of your Windows

   logon

   login account, but you can change this account by selecting the option:

     

   Use Microsoft SQL Server Authentication.

    If

   If you choose this option, SQL Enterprise Job Manager opens a new window where you have to specify the Login Name and Password for your SQL Server login account. Click Next.

10. The next window prompts you to review Review the installation settings. If you want to To change them, click click Back to go to the respective window. If you are ready to install SQL Enterprise Job Manager, click Install. The Installation process begins. 
11. When the installation of SQL Enterprise Job Manager finishes, a confirmation of completed installation is displayed. Click Finish.
12. To access your instance of SQL Enterprise Job Manager, you have to access your IDERA Dashboard. Use the following link in the browser of your choice: http://<ServerName>:9290 where ServerName is the name of the machine on which you installed the IDERA Dashboard.

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...