Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I found some SQL Server replication-related jobs that do not show up under the jobs folder in SSMS. Can anybody explain why this is, please?

Thanks.

share|improve this question

1 Answer

up vote 5 down vote

In replication their are 3 Database/Servers you have:

  1. Publisher : where the data comes from
  2. Distribution : handles tracking and packaging of data to be sent to the subscriber
  3. Subscriber : receives the data

Depending on the type of replication you have setup, the replication jobs may be running at a different location than you expect, ie:

Under Pull replication, there will be jobs running on the Subscriber to pull the data from the distribution database vs Push replication, the job will be running on the Distribution server.

For more info see MSDN: Replication Agents Overview

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.