May 11, 2020 at 2:58 pm
we configured transactional replication with account as sql user having sysadmin on sql , but when we tried to run the job getting error
Step 1 failedreason: The LogReader subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.'
How to slove this error ?
May 11, 2020 at 5:12 pm
Did you check the SQLAgent.out file as the error indicates?
Sue
May 12, 2020 at 6:28 am
checked the sql agent out file but did not find any information execpt the
Step 1 failedreason: The LogReader subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.'
May 12, 2020 at 5:57 pm
That's the error from the SQL Server error log, not the SQLAgent.out file. There are two different error files - one for SQL Server and one for SQL Server Agent. You need to look at the Agent error file.
The agent error log could indicate any issue with loading the subsystem and the file it is looking for should match what is in msdb.dbo.syssubsystems for the LogReader subsystem. Check the file path, adjust in syssubsystems if needed. That's one scenario but you need to check the agent error log, not the SQL Server error log.
Sue
May 12, 2020 at 7:31 pm
Also try restarting the SQL Server Agent Service to see if subsystem loads.
Sue
May 13, 2020 at 7:29 am
i checked the sqlagent.out file and also the msdb.subsystem , as the sql is installed on D drive the log reader subsystem file is in D drive .
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply