BUG: Replication Agent Might Run Continuously Even When the Replication Job is Completed (818552)

MORE INFORMATION

In SQL Server 2000 Service Pack 3, when you run the replication agent by using a proxy account, a separate process is generated that is built in the Microsoft Windows subsystem. Therefore, the agent process runs in a separate window that requires user interaction (CTRL+C) to end the agent process. Because the agent process runs in the background, user interaction becomes impossible, and the agent process runs continuously. You can stop the agent process by using Task Manager.

Steps to Reproduce the Behavior

1. Set the SQL Server Agent to use a proxy account.
2. Set the replication job owner to a user who does have have System Administrator credentials.
3. Set the replication job not to run continuously or incorporate an error in the replication job command line. To do so, follow these steps:
   1. Right-click the replication job, and then click Properties.
   2. In the <Job name> Properties - <Server Name> dialog box, click the Steps tab.
   3. Click Edit.
   4. In the Edit Job Step - <Job name> dialog box, under the Command section,
      remove the -Continuous flag from the command line.
      -or-
      Change the name of the publisher to the name of a publisher that does not exist.
      Note Changing the publisher name is to simulate an error.
   5. Click Apply, and then click OK.
   6. To save the job settings, click Apply, and then click OK
4. Run the job.

Note Note that the job appears to run in the SQL Server Enterprise Manager, and that the job history shows that the job is either completed or failed. In Task Manager, you can see that the agent process continues to run.