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.
- [ @job_login= ] 'job_login'
Is the login for the Microsoft Windows account under which the agent runs. job_login is nvarchar(257), with no default. This Windows account is always used for agent connections to the Distributor.
- [ @job_password= ] 'job_password'
Is the password for the Windows account under which the agent runs. job_password is sysname, with no default.
Security Note: Do not store authentication information in script files. For best security, login names and passwords should be supplied at runtime.
- [ @job_name= ] 'job_name'
Is the name of an existing agent job. job_name is sysname, with a default value 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 value of 0. A value of 1 means that the procedure is being executed from the Publisher on the publication database.
Other ResourcesHow to: Enable Updating Subscriptions for Transactional Publications (Replication Transact-SQL Programming)
How to: Upgrade Replication Scripts (Replication Transact-SQL Programming)
Updatable Subscriptions for Transactional Replication