Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

sp_add_targetservergroup

SQL Server 2000

Adds the specified server group.

Syntax

sp_add_targetservergroup [ @name = ] 'name'

Arguments

[@name =] 'name'

Is the name of the server group to create. name is sysname, with no default. name cannot contain commas.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

Target server groups provide an easy way to target a job at a collection of target servers. For more information, see "sp_apply_job_to_targets" in this volume.

Permissions

Only members of the sysadmin fixed server role can execute this procedure.

Examples

This example creates the target server group named Servers Processing Customer Orders.

USE msdb
EXEC sp_add_targetservergroup 'Servers Processing Customer Orders'

See Also

sp_delete_targetservergroup

sp_help_targetservergroup

sp_update_targetservergroup

System Stored Procedures

Show:
© 2015 Microsoft