Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Please anybody suggest me how to write a script which compares the jobs on the primary and the secondary server.

Thanks, Venk

share|improve this question

Red-Gate SQL Compare will compare and script all (or at least most?) objects between two SQL Servers.

They also offer an API that lets you write .NET code to programatically compare and sync objects.

share|improve this answer

Your Answer

 
discard

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