sp_help_targetserver (Transact-SQL)
Applies to: 
SQL Server
Lists all target servers.
Transact-SQL syntax conventions
Syntax
sp_help_targetserver [ [ @server_name = ] N'server_name' ]
[ ; ]
Arguments
[ @server_name = ] N'server_name'
The name of the server for which to return information. @server_name is sysname, with a default of NULL.
Return code values
0 (success) or 1 (failure).
Result set
If @server_name isn't specified, sp_help_targetserver returns this result set.
| Column name | Data type | Description |
|---|---|---|
server_id |
int | Server identification number. |
server_name |
nvarchar(30) | Server name. |
location |
nvarchar(200) | Location of the specified server. |
time_zone_adjustment |
int | Time zone adjustment, in hours, from Greenwich mean time (GMT). |
enlist_date |
datetime | Date of the specified server's enlistment. |
last_poll_date |
datetime | Date the server was last polled for jobs. |
status |
int | Status of the specified server. |
unread_instructions |
int | Specifies whether the server has unread instructions. If all rows are downloaded, this column is 0. |
local_time |
datetime | Local date and time on the target server, which is based on the local time on the target server as of the last poll of the master server. |
enlisted_by_nt_user |
nvarchar(100) | Microsoft Windows user that enlisted the target server. |
poll_interval |
int | Frequency in seconds with which the target server polls the master SQLServerAgent service in order to download jobs and upload job status. |
Permissions
To execute this stored procedure, a user must be a member of the sysadmin fixed server role.
Examples
A. List information for all registered target servers
The following example lists information for all registered target servers.
USE msdb;
GO
EXEC dbo.sp_help_targetserver;
GO
B. List information for a specific target server
The following example lists information for the target server SEATTLE2.
USE msdb;
GO
EXEC dbo.sp_help_targetserver N'SEATTLE2';
GO