sql server replication: Is it possible to merge continuously between 8am and 5pm? -- sql server replication

Is it possible to merge continuously between 8am and 5pm?

Rob Kraft
4/29/2004 2:47:23 PM

sql server replication:

I have servers in a merge scenario that replicate every ten minutes. When
changes occur, they need to replicate fairly quickly (within 30 minutes),
but changes may not occur in every hour.

I think it would be most efficient to run continuous rather than every 10
minutes. However, I would really like replication to not be running at all
outside of the 8am-5pm window. Is it possible to have continuous
replication, but only from 8am to 5pm? The SQL Enterprise Manager does not
seem to allow for it.

Rob Kraft

Re: Is it possible to merge continuously between 8am and 5pm?

Michael Hotek
4/29/2004 4:29:19 PM

Sure. Add a job that runs at 8AM and again at 5PM. What does this job do?
It changes the schedule on the replication job.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com