Trans ^ Merge Repl Scheduling in SMS 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LPR-3rd - 29 Sep 2006 17:41 GMT

I cannot find where to change the 'schhedule' in SMS 2005. I can go to
EM & do it...by finding it in the distribution agents.

Do I have to navigate to the job in the SQL Agent->Jobs folder??

Larry...

Reply to this Message

Hilary Cotter - 29 Sep 2006 18:50 GMT

That's one way to do it. Another is to open up Replication Monitor, expand
your publisher, click on subscription watch list, Right click on your
distribution agent, and select view details, select Action, and Distribution
Agent Properties. Click on Schedules.

Its on days like this I pine for Enterprise Manager.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I cannot find where to change the 'schhedule' in SMS 2005. I can go to
> EM & do it...by finding it in the distribution agents.
>
> Do I have to navigate to the job in the SQL Agent->Jobs folder??
>
> Larry...

Reply to this Message

LPR-3rd - 29 Sep 2006 19:43 GMT

Thanks!!!! I miss many 'tricks' that EM allowed up to do also!!!!

> That's one way to do it. Another is to open up Replication Monitor, expand
> your publisher, click on subscription watch list, Right click on your
[quoted text clipped - 23 lines]
> >
> > Larry...

Reply to this Message