EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Target Servers


Multiserver administration which consists in automating administration across multiple instances of SQL Server is performed when there is a necessity to manage two or more servers and to schedule information flows between enterprise servers for data warehousing.

 

In a multiserver system, there is at least one master server and at least one target server.

A master server distributes jobs to target servers, and receives events from them. A master server also stores the central copy of job definitions for jobs that are run on target servers. Target servers connect periodically to the master server to update their schedule of jobs. If a new job exists on the master server, the target server downloads the job. After the target server completes the job, it reconnects to the master server and reports the status of the job.

 

Before using target servers, make sure that the SQL Server Agent service is running.

 

menuTargetServers

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.