RedShift Scheduler

RedShift scheduler allows you to schedule certain actions, including:

These are executed on a scheduled basis.

To schedule any of these actions go to the RedShift section, and from the context menu select Schedule.

Under scheduler windows, select the action you want to execute.

Under the Schedule section, select when the action should be executed.

Schedule Snapshot

When you schedule snapshot, you have the option to schedule maintenance that can be used to remove old snapshots based on the selected criteria.

Schedule Cluster

Cluster scheduler gives you the option to modify node type as well as total nodes.

Using this scheduler, you are able to change the processing power of your cluster based on needs (e.g. more power during days and less during nights or weekends).

Schedule Shut Down Cluster

When you schedule shut down of the RedShift cluster, you have an option to create snapshot before RedShift is terminated.

To do this, check Take Snapshot before Shut Down and enter snapshot name.

This option is useful if you plan to schedule shut down and restore for the same cluster.

Schedule Restore Cluster

When you schedule restore cluster, you have to provide cluster name (identifier) as well as which snapshot the cluster should be restored from.

You can choose one of your existing snapshots, or restore cluster from the latest snapshot.

To restore from the latest snapshot, check “Restore From the Last Snapshot”.