sp_addqreader_agent (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Adds a Queue Reader agent for a given Distributor. This stored procedure is executed at the Distributor on the distribution database or at the Publisher on the publication database.

Transact-SQL syntax conventions

Syntax

sp_addqreader_agent
    [ [ @job_login = ] N'job_login' ]
    [ , [ @job_password = ] N'job_password' ]
    [ , [ @job_name = ] N'job_name' ]
    [ , [ @frompublisher = ] frompublisher ]
[ ; ]

Arguments

[ @job_login = ] N'job_login'

The login for the Windows account under which the agent runs. @job_login is nvarchar(257), with a default of NULL. This Windows account is always used for agent connections to the Distributor.

[ @job_password = ] N'job_password'

The password for the Windows account under which the agent runs. @job_password is sysname, with no default.

Important

Don't store authentication information in script files. For best security, login names and passwords should be supplied at runtime.

[ @job_name = ] N'job_name'

The name of an existing agent job. @job_name is sysname, with a default of NULL. This parameter is only specified when the agent is created using an existing job instead of a newly created job (the default).

[ @frompublisher = ] frompublisher

Specifies whether the procedure is being executed at the Publisher. @frompublisher is bit, with a default of 0.

A value of 1 means that the procedure is being executed from the Publisher on the publication database.

Return code values

0 (success) or 1 (failure).

Remarks

sp_addqreader_agent is used in transactional replication.

sp_addqreader_agent must be executed at least once at a Distributor that supports queued updating after sp_adddistributiondb but before sp_addpublication.

The Queue Reader Agent job is removed when you execute sp_dropdistributiondb.

Permissions

Only members of the sysadmin fixed server role can execute sp_addqreader_agent.

Related content