alwayson availability groups- Syncing jobs

  • Can you guys share how you are taking care of new jobs and changes in the existing jobs to replicate to secondary replicas? It's giving a hard time to keep track on these changes and syncing jobs across different environments. Any suggestions?

  • New jobs, just script to all replicas at deployment time

    Existing jobs, are they really changing that often??

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Not really. But there's a high chance of commenting out some scripts in job on one replica and forgetting it to edit on the other one. I guess it's better we have some kind of alert setup to warn us on these kind of changes.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply