log reader agent

• lioi

  SSC Journeyman

  Points: 84

  More actions

  June 10, 2002 at 6:06 am

  #158569

  How can I start\stop log reader agent in a transactional replication, using stored procedures or Visual Basic code ?

  Thank you

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 10, 2002 at 7:09 am

  #430581

  The easiest way I've found is to use sp_stop_job to stop the job that called the agent rather than trying to stop the agent itself.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter