Sql Replication


  • Sql Server Agent Error: Request to run job name-pc\name-databasename-name\name-15(from User name-pc\name) refused because the job is already running from request by User sa. Changed database context to "databasename". (Microsoft SQL Server , Error: 22022).

    Any Help pls?
    Monday, April 29, 2013 1:10 AM

All replies

  • Hello, 

    as error message states, you are  trying to run the job which is already running.

    Check the sql server agent and look for the particular job and you would see the job running,that's why you are seeing this error.

    It looks to me like you are trying to start the job from replication folder but the job is already running in the sql server agent. look in the sql job monitor and stop the job and then try to run the job again. btw, since the job is already running, why do you want to run again???

    Hope it Helps!!

    • Proposed as answer by KEROBIN Tuesday, April 30, 2013 10:15 AM
    Monday, April 29, 2013 1:41 AM
  • i connect to the another instance name in my PC it's working but when i connect to the another instance name on Network it's not working and alert a error message like this.

    Pls Help!!!

    Monday, April 29, 2013 2:52 AM