chore(ci): migrate Scheduled workflow to Scheduled pipeline

[bednar]

Proposed Changes

The Scheduled Workflows uses client for nightly builds but the scheduled workflows will be phased out by the end of 2022. The CircleCI's configuration has to be migrate to Scheduled pipelines.

• https://circleci.com/docs/workflows/#scheduling-a-workflow
• https://circleci.com/docs/scheduled-pipelines/#migrate-scheduled-workflows

Configured trigger:

Checklist

• [x] Rebased/mergeable
• [x] make test completes successfully
• [x] Commit messages are conventional
• [x] Sign CLA (if not already signed)