sp_help_targetserver

Transact-SQL Reference

Transact-SQL Reference

sp_help_targetserver

Lists all target servers.

Syntax

sp_help_targetserver [ [ @server_name = ] 'server_name' ]

Argument

[@server_name =] 'server_name'

Is 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 NT® user that enlisted the target server.
poll_interval int Frequency with which the target server polls the Master SQLServerAgent service in order to download jobs and upload job status.
Permissions

Permissions to execute this procedure default to the sysadmin fixed server role and the db_owner fixed database role, who can grant permissions to other users.

Examples

This example lists information for all servers, and then only for the LONDON1 target server.

USE msdb
EXEC sp_help_targetserver
EXEC sp_help_targetserver 'LONDON1'

See Also

sp_add_targetservergroup

sp_delete_targetserver

sp_delete_targetservergroup

sp_update_targetservergroup

sysdownloadlist

System Stored Procedures