sys.sp_addqreader_agent

Description

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. The login for the Windows account under which the agent runs. This Windows account is always used for agent connections to the The password for the Windows account under which the agent runs.

Syntax

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