I would like to Create a schedule in Databricks that runs a job on 1st working day of every month

NDK_1
New Contributor II

I would like to create a schedule in Databricks that runs a job on the first working day of every month (working days referring to Monday through Friday). I tried using Cron syntax but didn't have any luck. Is there any way we can schedule this in Databricks?

shan_chandra
Databricks Employee
Databricks Employee

@NDK_1 - Cron syntax won't allow the combination of day of month and day of week. you can try creating two different schedules  - one for the first day, second day of the month and then add custom logic to check if it is an working day and then trigger your actual logic.