Re: Replication maintenance jobs

Yes, you can. Something is very wrong here.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
"NC3" <ncoleman3@xxxxxxxxx> wrote in message
news:1191942570.546783.323560@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 9, 7:47 am, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
These jobs will be present on the remote distributor. Did you look on
the
remote distributor in the miscellaneous jobs folder on SQL 2000 and in
the
other jobs will show up in the jobs folder in SQL 2005.

Can you check to make sure they are not in those locations?

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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

Looking for a FAQ on Indexing Services/SQL
FTShttp://www.indexserverfaq.com"NC3"; <ncolem...@xxxxxxxxx> wrote in
message

news:1191441595.530216.233700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



We've just migrated to a new firm wide application that uses
transactional replication for reporting purposes. I've configured
replication 2 or 3 different times while in test/development without
many issues. On cutover Monday replication became a show stopper due
to configuration issues mainly properly securing each component of the
topology.

I have a remote distributor configured to manage the maintenance jobs
for the replication process. After verifying the proces is actually
replicating data I noticed that the only jobs created are the Snapshot
agent, Log Reader agent and the distribution agent jobs.

During development I also noticed additional jobs that have not been
created.

Reinitialize subscriptions having data validation failures
Agent history clean up: distribution
Replication monitoring refresher for distribution.
Replication agents checkup
Distribution clean up: distribution

I reviewed the Publisher and Subscriber and located the Expired
subscription clean up oon the publication server.

How can I get the additional maintenance jobs created and equally
important why wouldn't the jobs be created by the wizard during
configuration.- Hide quoted text -

- Show quoted text -

That's the problem they do not show in the jobs folder in SQL 2005 as
expected. I have reconfigured twice and both times they fail to be
created. Can I script the jobs from a development installation which
created the jobs as expected and change the relevant parameters and
have them work successfully?

It seems to me if the additional jobs are not created the over all
health of the repllcation environment can become negatively effected.

Thanks for all the repsonses!



.

Relevant Pages

  • Re: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions wi
    ... Note the History Retention group. ... Looking for a SQL Server replication book? ... >> Looking for a SQL Server replication book? ... I know the distribution agents have been running ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication maintenance jobs
    ... These jobs will be present on the remote distributor. ... Looking for a SQL Server replication book? ... agent, Log Reader agent and the distribution agent jobs. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication maintenance jobs
    ... other jobs will show up in the jobs folder in SQL 2005. ... Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html ... Log Reader agent and the distribution agent jobs. ...
    (microsoft.public.sqlserver.replication)
  • Replication maintenance jobs
    ... transactional replication for reporting purposes. ... to configuration issues mainly properly securing each component of the ... replicating data I noticed that the only jobs created are the Snapshot ... Log Reader agent and the distribution agent jobs. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge replication: subscriber jobs missing.
    ... First, it's transactional replication, not merge. ... I was able to see the jobs when I looked at the server and was able ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
Loading