How to programming start log reader agent

• Rachell-76794

  Ten Centuries

  Points: 1067

  More actions

  August 12, 2003 at 6:26 am

  #81007

  Can someone tell me what system stored procedure can start and stop the log reader agent? This is releate my previous post, I need use T-SQL programming stop log reader agent then rebuild index then restart it.

  Thank you for the help

  feifei liu

  
  Rachel

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 12, 2003 at 7:06 am

  #469556

  Easiest way I've found is to call sp_stop_job on the job that runs the logreader.

  Andy

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

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

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  August 12, 2003 at 10:16 am

  #469607

  agree..but the next time you start the log reader agent, it will read all the transactions and commands made when it was stopped.