Skip to content

How do I synchronize SQL Server Agent jobs between the primary and secondary hosts in my RDS for SQL Server Multi-AZ instance?

1 minute read
0

I have an Amazon Relational Database (Amazon RDS) for Microsoft SQL Server Multi-AZ instance. I want to synchronize SQL Server Agent jobs between the primary and secondary hosts in my instance.

Resolution

Note: The following resolution doesn't apply to Amazon RDS Custom for SQL Server.

To automatically synchronize SQL Server Agent jobs between the primary and secondary hosts in your instance, turn on SQL Server Agent job replication. Make sure that you turn on job replication as an administrator on the primary instance.

For more information, see Multi-AZ deployments for Amazon RDS for Microsoft SQL Server.