sp_help_targetserver (Transact-SQL)
Lists all target servers.
If server_name is not 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 | Whether the server has unread instructions. If all rows have been 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. |
A. Listing 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. Listing 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
