Replication schedule

Here's my problem
I have setup a transactional replication with a push
subscription, I schedule it to run every hour, every think
works good, however when the schedule start synchronizing
it never stops so its not stating at the next hour, I have
to manually click stop synchronizing and then it starts
again.
Please help!!!
Expand Replicaiton Monitor, expand the agents folder, expand the
distribution agents folder, right click on your distribution agent and
select agent properties. then select the steps tab. Click on Run Agent and
then click on the Edit button.
in the command section press the end key, remove the -Continuous statement,
click apply, ok, apply ok, right click on your distribution agent again and
select start agent.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"amw" <amw@.1800wheelchair.com> wrote in message
news:0b7b01c48b80$61dbdc50$a301280a@.phx.gbl...
> Here's my problem
> I have setup a transactional replication with a push
> subscription, I schedule it to run every hour, every think
> works good, however when the schedule start synchronizing
> it never stops so its not stating at the next hour, I have
> to manually click stop synchronizing and then it starts
> again.
> Please help!!!
|||Thanks for your reply
I follow your answer but I don't see the -Continuous
statement on the distribution agent schedule, but I see it
in the log reader agent schedule, should I remove it from
there? I think the log reader should run continuous.

>--Original Message--
>Expand Replicaiton Monitor, expand the agents folder,
expand the
>distribution agents folder, right click on your
distribution agent and
>select agent properties. then select the steps tab. Click
on Run Agent and
>then click on the Edit button.
>in the command section press the end key, remove the -
Continuous statement,
>click apply, ok, apply ok, right click on your
distribution agent again and[vbcol=seagreen]
>select start agent.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"amw" <amw@.1800wheelchair.com> wrote in message
>news:0b7b01c48b80$61dbdc50$a301280a@.phx.gbl...
think[vbcol=seagreen]
synchronizing[vbcol=seagreen]
have
>
>.
>
|||don't touch the log reader!
If it is not present in your distribution agent, you have a lot of data to
send to your subscriber. In time the job will finish.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"amw" <amw@.1800wheelchair.com> wrote in message
news:0c2801c48b8f$7ad28e20$a501280a@.phx.gbl...[vbcol=seagreen]
> Thanks for your reply
> I follow your answer but I don't see the -Continuous
> statement on the distribution agent schedule, but I see it
> in the log reader agent schedule, should I remove it from
> there? I think the log reader should run continuous.
> expand the
> distribution agent and
> on Run Agent and
> Continuous statement,
> distribution agent again and
> think
> synchronizing
> have