Hi Muhammad,

For scheduling part, it really depends on dbt only and if you use already a solution for orchestration. I think you can use their dbt Cloud service or you can use any scheduling or orchestration tool to start a dbt run job.

For example Airflow or some tools found here https://victorcouste.github.io/data-tools/#orchestration

Victor