You can define which SQL Server instances you want to add to your SQL Enterprise Job Manager environment. You can only monitor jobs from registered SQL Server instances. 

You can add new SQL Server instances from the following sections:

You can also Import instances using the respective option under the Instances section from the Administration tab.

Read-only users cannot do the following actions on the Instances tab:

  • Add/register new SQL Server instances
  • Remove registered SQL Server instances
  • Change instances properties
  • Perform actions on SQL Server Agents

When you open the Add SQL Server Instance wizard, you have the following sections:

Instance

To add instances you can:

Specify the Data Collection Settings:

Determine if you want to monitor the Windows Tasks of your added instances. You can specify the following options:

Click Next to go to the next section.

Credentials

SQL connection credentials

SQL Enterprise Job Manager connects to registered SQL Server instances to collect information. The collection service requires permissions to connect and gather information using the account you specify. 

By default, SQL Enterprise Job Manager connects using the SQL Enterprise Job Manager service account. However, if you need to provide alternative credentials you can also choose from:

If you select a Windows user account or a SQL Server login account, type the respective user name and password.

SQL Enterprise Job Manager uses this account for SQL queries to gather availability and configuration data.

WMI connection credentials

Specify the credentials SQL Enterprise Job Manager will use to access Windows configuration data of the computer that hosts the registered instance. You can choose to use the SQL Enterprise Job Manager service account or a Windows user account. If you select the latter, you have to provide the respective user name and password. 

You can test the correctness of your credentials by clicking TEST CREDENTIALS.

Information

On this section, you can specify additional information for your instances like Owner, Location, and Comments

Although none of these fields are compulsory, Owner, Location, and Comments provide a powerful method for grouping instances and organizing your managed instances.  

Use the Owner and Location drop-down lists to access previously registered options.

Maintenance

Use this section to specify the maintenance schedule for the instances you are adding.

You can define two types of schedules:

 When you choose Recurring, you can define the frequency of your maintenance schedule. You can select from the following frequencies:

These options are also available on the Maintenance tab:

Finish

On this section, you can review your instance registration details such as: Instance, Data Collection Interval, Keep Data for, SQL Connection Credentials, Owner, Location, and Comments.

To change any of these registration details, you can do one of the following:

After you review your registration details, click FINISH. 

SQL Enterprise Job Manager registers your SQL server instances in the repository and immediately begins to collect instances information like availability, configuration, and job handling information. 

After registration, you can still change these settings. Go to Edit instance properties for more information.



 |   |  |  |  |