Online Documentation for SQL Manager for SQL server

Target Servers manager

The Target Servers manager is intended for easy and efficient management of target servers when multiserver administration is performed. The Target Servers manager allows you to browse the list of target servers and manage them efficiently.


To launch the tool, select the Services | SQL Server Agent | Target Servers main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | Target Servers item from the context menu.


Target Servers - Target Servers manager



The list displays the target servers as a grid with the following columns: Server Name, Location, Enlist Date, Last Poll Date, Poll Interval.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


Right-click an item within the list to call the context menu allowing you to create a new target server using the Add New Target Server dialog, delete the selected target server, refresh the list, or show/hide columns of the list. Using the context menu you can also export the list of target servers to any of supported output file formats.


Target servers management tools are also available through the Navigation bar of the Target Servers manager.


The Add New Target Server dialog allows you to register a new target server.


Target Servers - Add target server



Target server

Type in or use the drop-down list to select the server instance to be registered.



Specify the target server location.