Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use the checkbox next to each instance to select them and click the required option from the top bar menu or from the gear the Image Added gear icon of any selected instance.

The available options are:

  • Remove - use this option to delete/remove selected instances from your environment when you do not want to monitor them any longer. SQL Enterprise Job Manager stops collecting information from this instance, its jobs, will not generate related alerts, and will not display any related information.
  • Edit credentialsProperties - use this option to change instance properties such as owner, location, collection interval, etc. For more information, go to Editing your SQL Server instance properties. This option is also available on the Instance tab top bar menu.
  • Edit Credentials - select this option to edit if you select this option, you can change the connection credentials that SQL Enterprise Job Manager uses to connect to the selected instances. This option is also available on the Instance tab top bar menu. Edit Properties -
  • Start SQL Server Agent - if the SQL Server Agent service on the selected instances is not running, use this option to change the owner, location, comments, and data collection settings of the selected instances. start it. 
  • Stop SQL Server Agent - if the SQL Server Agent service on the selected instances is running, use this option to stop it.  
  • Restart SQL Server Agent - Use this option to restart the SQL Server Agent service on your selected instances. 
Tip

In order to start or stop the SQL Server Agent, the SQL Server service account must have permissions to start/stop services.

Warning

Read-only users cannot remove or edit credentials of several selected instances.

...