By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| SchId | FrequencyMinute |
|---|---|
| A | 480 |
| B | 720 |
| JobId | SchId | ST |
|---|---|---|
| 20210820120001 | A | 2021-08-20 00:00:00.000 |
| 20210820120002 | A | 2021-08-20 08:00:00.000 |
| 20210820120003 | A | 2021-08-20 16:00:00.000 |
| 20210820120004 | B | 2021-08-20 00:00:00.000 |
| 20210820120005 | B | 2021-08-20 12:00:00.000 |