sp_help_targetserver (Transact-SQL)
Applies to: SQL Server
Lists all target servers.
Transact-SQL syntax conventions
Syntax
sp_help_targetserver
[ [ @server_name = ] 'server_name' ]
Arguments
[ @server_name = ] 'server_name'
The name of the server for which to return information. server_name is nvarchar(30), with a default of NULL.
Return Code Values
0 (success) or 1 (failure)
Result Sets
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. |
Permissions
To execute this stored procedure, a user must be a member of the sysadmin fixed server role.
Examples
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
See Also
sp_add_targetservergroup (Transact-SQL)
sp_delete_targetserver (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
dbo.sysdownloadlist (Transact-SQL)
System Stored Procedures (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for