sp_helplogreader_agent (Transact-SQL)
Returns properties of the Log Reader Agent job for the publication database. This stored procedure is executed at the Publisher on the publication database.
Column name | Data type | Description |
|---|---|---|
id | int | ID of the agent. |
name | nvarchar(100) | Name of the agent. |
publisher_security_mode | smallint | Security mode used by the agent when connecting to the Publisher, which can be one of the following: 0 = SQL Server Authentication 1 = Windows Authentication. |
publisher_login | sysname | Login used when connecting to the Publisher. |
publisher_password | nvarchar(524) | For security reasons, a value of ********** is always returned. |
job_id | uniqueidentifier | Unique ID of the agent job. |
job_login | nvarchar(512) | Is the Windows account under which the Log Reader Agent runs, which is returned in the format domain\username. |
job_password | sysname | For security reasons, a value of ********** is always returned. |
