Share via

How to sync SQL Agent jobs in AG

Chaitanya Kiran 821 Reputation points
2023-12-11T10:52:44.5566667+00:00

How to sync SQL Agent jobs in AG(Availability Group)

SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,536 Reputation points
    2023-12-12T02:09:19.3466667+00:00

    Hi @Chaitanya Kiran,

    You may also check this blog if you are using SQL Server 2019 and earlier.

    Sync SQL Logins and Jobs

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments
  2. Javier Villegas 905 Reputation points MVP
    2023-12-11T13:23:59.2633333+00:00

    Hello

    Natively you cannot sync the SQL Jobs in AGs, unless you use SQL Server 2022 Contained Availability Groups

    if you are using AGs you can use DBATools Sync-DbaAvailabilityGroup

    Regards

    Javier

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.