Support scheduled autoscaling

[Lou1415926]

Today Copilot supports autoscaling by target tracking: it scales up/down depending on the usage of CPU/memory or response time , number of requests, and etc.

It'd be great if Copilot also supports scheduled autoscaling. For example, scaling to X at 9AM to 18PM every Saturday.

Related: #4233 (comment)

[biokraft]

Bumping this as I think this would be a great addition.

[icruwrks]

If scaling has already been set in the manifest file, it can be set using YAML Patch Overrides.

cfn.patches.yml

- op: add
  path: /Resources/AutoScalingTarget/Properties/ScheduledActions
  value:
    - ScalableTargetAction:
        MinCapacity: 10 # Scale to 10
        MaxCapacity: 10
      Schedule: "cron(0 9 ? * SAT *)"
      ScheduledActionName: ScaleTo10EverySaturdayFrom9
      Timezone: Asia/Tokyo # If you need to set the time zone
    - ScalableTargetAction:
        MinCapacity: 1 # Scale to 1
        MaxCapacity: 10
      Schedule: "cron(0 18 ? * SAT *)"
      ScheduledActionName: ScaleTo1EverySaturdayFrom18
      Timezone: Asia/Tokyo # If you need to set the time zone

I look forward to your formal support!