O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Maintenance jobs

When we configure replication, it creates some jobs that ensure the smooth functioning of replication. Here is a brief introduction to these jobs.

Agent history clean up: distribution

This job will remove replication agent history from the distribution database. By default, this job runs every ten minutes.

Distribution clean up: distribution

This job will remove replicated transactions from the distribution database. It also verifies whether subscription is synchronized with the maximum retention period. If maximum retention period exceeds, it will deactivate the subscription. By default, this job runs every ten minutes.

Expired subscription clean up

This job will verify if the subscription is expired. If it is, it will remove it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required