You can add new SQL Server instances by selecting the Add Instance option from the following sections:
- Overview tab tab - top Top menu bar of the All Instances section.
- Schedule tab tab - top Top menu bar of bar of the Operation list.
- Instances tab tab - top Top menu bar of bar of the Instance list.
- Administration tab tab - under Under the Instances section.
You can also Import instances using the Import SQL Servers option under the Instances section from the Administration tab.
- Type the name of instance or instances you want to register in the SQL Server Instance boxbox. Use a semicolon to separate several instances.
- Use the Browse button button to access a list of discovered instances that have not been registered yet with SQL Enterprise Job Manager. Check the box next to the instances you want to add , and click Apply.
Specify the Data Collection Settings:
- 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 Select this option to keep tasks and their respective history if you decide to stop monitoring them.
Use the option TEST CREDENTIALS to make sure the credentials specified can gather data for instances and host computers.
On In this section, you can specify additional information for your instances like Owner, Location, and Comments.
You can also select the Enabled option option to enable the schedulte schedule type for the instance.
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 as the 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 as the 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.
- 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.
On In this section, you can review your instance registration details such as : Instance, Data Collection Interval, Keep Data for, SQL Connection Credentials, WMI Connection Credential, Location, Owner, and Comments.