Transactional Replication - Modify Schedule

[Steffi1013]

I set up transactional replication with the snapshot agent doing a continuous read and I need to know where to go to change the schedule so that it only does a push once every 8 hours to the subscriber.

Please help!

 

[mrdenny]

Edit the SQL Agent job and remove the -continous switch from the command line. Then schedule the job to run as often as needed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog