SQL Server 2008 Replication database occurs when you perform a SQL Server Agent job error

1. Description of the situation

With the SQL Server Database Replication Wizard, it is easy to copy a database from one server to another, and the steps are simple.

However, "Execute SQL Server Agent job Error" often occurs in the actual operation process, click to see the details will prompt "Job failure for more information, please check the event log on the target server."

2. Treatment options

The general reason for this behavior is that the permissions of the SQL Server Agent service for the target server are too low. Change the agent service permissions to the LocalSystem account.

A. Start – Program –sql SERVER Configuration Manager

B. Click on the left "SQL SERVER" service

C. In case, change both SQL Server Agent and SQL Server two services to LocalSystem

3. Other

Using the above scenario is still unresolved, there may be a SQL Server version problem, SP1 patch

SELECT  SERVERPROPERTY(‘productlevel‘) AS ‘Service Pack‘ ,SERVERPROPERTY(‘edition‘) AS edition ,SERVERPROPERTY(‘productversion‘) AS ‘build number‘

If shown, the description is not patched, the SP1 patch can be (https://www.microsoft.com/zh-cn/download/details.aspx?id=26727)

SQL Server 2008 Replication database occurs when you perform a SQL Server Agent job error