AWS

External Article

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

  • Article

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.

2017-08-30

2,895 reads

Blogs

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Storytelling with Data – Enertia User Conference 2022

By

Thank you to everyone who attended my session at the Enertia User Conference in...

Read the latest Blogs

Forums

Missing weekend data to Zero

By LearnSQL

Hi All, I have a requirement that if there is no weekend data then...

Alight Motion is safe for users?

By Zara Alight1

Description: Alight Motion edits application that allows you to edit videos in the Android smartphone....

How to calculate orders historically, during month

By Zond Sita

Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers