[devops] scheduled workflows are broken

[FrankLeeeee]

Currently we have the following scheduled workflow:

1. weekly example check
2. weekly full unit test
3. weekly compatibility test

Some scheduled workflows are not functioning correctly now. For example, https://github.com/hpcaitech/ColossalAI/actions/runs/4032540127.

Efforts are required to make sure that these workflows work correctly.

Some suggestions:

1. make scheduled workflow an independent workflow file
2. connect the scheduled workflow with webhooks to our internal communication platform (another issue will be set up for this)

This issue is splitted into sub-issues:

1. example CI: [devops] example check scheduled workflow fails #2553
2. unit test [devops] build workflow is stopped due to low GPU memory threshold #2557
3. compatibility [devops] compatibility workflows should align with other workflows #2559