Sets the SQL Server Agent master server account name and password on the target server.
Applies to: SQL Server (SQL Server 2008 through current version).
SQL Server uses credentials to store the user name and password information that a target server uses to log in to a master server. This procedure sets the credential that SQL Server Agent for this target server uses to log in to the master server.
The credential specified must be an existing credential. For more information about creating a credential, see CREATE CREDENTIAL (Transact-SQL).
The following example sets this server to use the credential MsxAccount to log in to the master server.
USE msdb ; GO EXECUTE dbo.sp_msx_set_account @credential_name = MsxAccount ; GO