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. 

After you open you open the SQL Enterprise Job Manager installer file, follow these steps:

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

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

   Info
   The path C:\Program Files\Idera\SQLEJM\

 is

8. is displayed by default. If you want to change this path,

click 

9. click Change

 and

10. and select the folder where you want to install the product. Click Next.

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

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

    Info
    This name

will be

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

16. Specify the Service Account

 under

17. 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

18. 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

19. 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.

20. On the Service Ports

 section

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

    Info
    By default,

 SQL

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

 

23. You can change this value according to your requirements.

Take into account that

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

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

31. In the same window,

you can also

32. set

the 

33. the Connection Credentials

 that

34. that SQL Enterprise Job Manager

uses

35. will use to create this repository database.

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

logon

36. login account, but you can change this account by selecting the option:  Use Microsoft SQL Server Authentication.  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.

The next window prompts you to review
37. Review the installation settings.
If you want to
38. To change them,
click 
39. click Back to go to the respective window. If you are ready to install SQL Enterprise Job Manager, click Install
. The Installation process begins
40. . 
41. When the installation of SQL Enterprise Job Manager finishes, a confirmation of completed installation is displayed. Click Finish.
42. 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 > >

...