Page History
SQL Enterprise Job Manager allows you to view and edit the most important properties of your registered SQL Server instances.
If you select one or several SQL Server instances, you can find the the Edit Properties option option on the top bar menu from the Instances tab Instances tab or from the options displayed on the the 
gear icon.
The The Edit Instance Properties window wizard displays the following sections:
- Instance Details and Ownership
- Data Collection SettingsCredentials
You can edit any of these sections according to your needs.
| Warning |
|---|
Read-only users can only access a read-only version of the Edit Instance Propertieswindow wizard, they cannot change any of the displayed fields. |
Editing Instance Details and Ownership
You can define the owner, location, and add comments when you register an instance; however , if you did not type them before, or you want to change any of these fields, go to the Instance Details and Ownership section and make your required changes, then click click SAVE.
You can select other owners and locations from the respective drop-down options.
Data Collection Settings
When you register an instance, you define your data collection settings. You can change these settings anytime by editing these fields.
- The The Collection Interval lets allows you to define how often SQL Enterprise Job Manager collects data for your instance. This interval is specified in minutes or days.
- The section The Keep Data for lets you for section, allows you to determine how many days SQL Enterprise Job Manager keeps your data before grooming it. This interval is specified in days.
Credentials
These credentials allow you to connect to the SQL Server instances to collect their information. When you register an instance, you define these credentials; however, you can change them later on the Edit Instance properties window.
You can choose from:
- SQL Enterprise Job Manager service account - this account is defined when you install SQL Enterprise Job Manager.
- SQL Server login account - you need to provide the respective login and password to access this account.
- Windows user account - you need to provide the respective login and password to access this account.
| Tip |
|---|
You can test the correctness of your credentials by clicking TEST CREDENTIALS. Use this option to be sure SQL Enterprise Job Manager can gather data for your instances. |
| Tip |
|---|
For bulk operations on several instances, you can use the option Edit Credentials available under the gear icon or the top bar menu. |
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...