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 Edit Properties option on the top bar menu from the Instances tab or from the options displayed on the gear icon.
The Edit Instance Properties window displays the following sections:
- Instance Details and Ownership
- Data Collection Settings
- Credentials
You can edit any of these sections according to your needs.
Read-only users can only access a read-only version of the Edit Instance Properties window, 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 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 Collection Interval lets you define how often SQL Enterprise Job Manager collects data for your instance. This interval is specified in minutes or days.
- The section Keep Data for lets you determine how many days SQL Enterprise Job Manager keeps your data before grooming it. This interval is specified in days.
Determine if you want to monitor the Windows Tasks of your added instances. You can specify the following options:
- Monitor task for the instance(s) - Select this option if you want to monitor the tasks of your added instances
- Keep task and task history data for the instance(s) - select this option to keep tasks and their respective history if you decide to stop monitoring them.
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:-
- SQL Server login account
- Windows user account
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. Use this option to be sure SQL Enterprise Job Manager can gather data for your instances.
For bulk operations on several instances, you can use the option Edit Credentials available under the gear icon or the top bar menu.
Maintenance
Use this section to specify the maintenance schedule for the instances you are adding.
You can define two types of schedules:
- Recurring - select this option if you want SQL Enterprise Job Manager to perform the maintenance on a recurrent schedule.
- One time - choose this option to execute maintenance on a one-time schedule.
When you choose Recurring, you can define the frequency of your maintenance schedule. You can select from the following frequencies:
- Daily -if you select this option, specify the number of days SQL Enterprise Job Manager uses as interval to perform maintenance. Determine if you want to perform maintenance once per day, at a specific time of the day, or if you want to perform it every determined number of hours.
- Weekly - if you choose this option, specify the number of weeks SQL Enterprise Job Manager uses as interval to perform maintenance. You can select the days of the week when maintenance is executed. Additionally, you can determine the daily frequency, i.e. the exact time of the day when maintenance is performed or how many times per day the process is done.
- Monthly - when you select this option, you can determine on which days of the month SQL Enterprise Job Manager performs maintenance and with which exact monthly frequency. For example, you can define a maintenance schedule for the second Monday of the month, every 2 months.
These options are also available on the Maintenance tab:
- Determine the duration of your maintenance schedule by specifying the dates when the schedule begins and finishes.
- Specify how long the maintenance mode will last.
- Disable alerts and jobs during this period. In this section you have the following options:
- Disable Alerts during the maintenance - define which alerts severity you want to disable and if you want to disable alerts for jobs or instances.
- Disable non-maintenance jobs during maintenance - by selecting this option, no other jobs will run during the maintenance period.
- Stop maintenance jobs that run past the maintenance - by selecting this option, jobs that run past the maintenance will be stopped.