I am facing a problem regarding SQL Log Reader Agent. Whenever, I start SQL Server Agent, Log Reader Agent does not start. I have to start manually.
- Do I have start Log Reader Agent manually every time?
- How can I start Log Reader Agent via T-SQL?
Do I have start Log Reader Agent manually every time?
That depends - what schedule is attached to the log reader agent job? The log reader agent runs as a SQL Server Agent job and typically is assigned a schedule to start when SQL Server Agent starts. This schedule might be disabled or deleted hence why you're having to start it manually.
How can I start Log Reader Agent via T-SQL?
You need to start the SQL Agent job. First, get the name of the job, then add it to this script and execute it:
EXEC msdb..sp_start_job @job_name = '<lo reader agent job name goes here>';
This shouldn't be necessary though, you just need to find and fix the problem with the schedule for this agent.
NOTE: To get the name of the job, the simplest way is to open Job Activity Monitor and look in the Category column for Repl-Log Reader.