Automate progression of snapshots through pipelines

### Description

It would be useful to automate moving a snapshot to the next stage of the pipeline. To start, being able to trigger based on time (as soon as possible, every X minutes, at 00:00 each day) would be a great.

### Which customers would this be available to

None

### Have you provided an initial effort estimate for this issue?

I have provided an initial effort estimate