February 17, 2021

Bulk DMS task operations with JQ and Bash

List all DMS task arns

 aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn'

Stop all tasks

  
 for t in $(aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn') ; do
   aws dms stop-replication-task --replication-task-arn $task
 done

Start all tasks with full reload

  
 for t in $(aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn') ; do
   aws dms start-replication-task --replication-task-arn $task --start-replication-task-type reload-target
 done