topic Re: I would like to create a schedule in Databricks that runs a job every two weeks on Monday night 0:00 in Data Engineering

I would like to create a schedule in Databricks that runs a job every two weeks on Monday night 0:00

Eelke — Thu, 15 Jun 2023 07:57:49 GMT

This seems impossible with the cron that databricks is using but maybe I am wrong? However, if this is not possible it seems to me a missing feature, and thereby would like to suggest this feature to you 🙂

Re: I would like to create a schedule in Databricks that runs a job every two weeks on Monday night 0:00

etsyal1e2r3 — Fri, 16 Jun 2023 02:09:24 GMT

Well i havent looked at the specifiic options of the workflow scheduler recently but if you cant do every other week then just do it for every week but put a check in the beginning of the first workbook. If its not the 2nd week then exit the workbook with

dbutils.notebook.exit("This is an odd week for the scheduler. This workflow should run next week @ 0:00.")

You can add email notifications as well so you can ensure every other run works as planned 🙂

Re: I would like to create a schedule in Databricks that runs a job every two weeks on Monday night 0:00

Anonymous — Fri, 16 Jun 2023 03:11:48 GMT

Hi @Eelke van Foeken

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!