Databricks Community

pcbzmani · ‎07-03-2023

Dear All - I want to schedule a job in Workflow for every 30 days. So, when i try the below CRON expression it gives invalid cron expression. Anyone who already implemented this?

0 0 */30 * *

Vinay_M_R · ‎07-03-2023

To schedule a job in a workflow to run every 30 days, follow these steps:

1. Go to the "Workflows" section in the sidebar.
2. Find the job you want to schedule in the "Name" column on the "Jobs" tab and click on it.
3. In the "Job details" panel, click on "Add trigger".
4. Select "Scheduled" as the trigger type.
5. Specify the period as "Monthly" and choose the starting time and time zone.
6. Click on "Save".

Example of a cron expression for running a job every 30 days:

0 0 1 */30 * ?

Please note that the cron expression may vary depending on your specific scheduling requirements and the platform you are using.

pcbzmani · ‎07-03-2023

Hello @Vinay_M_R -> I want jobs to run on 30 days interval not on monthly. Reason for this to have log on every 30 days.

Vinay_M_R · ‎07-04-2023

Hi @pcbzmani

A cron expression doesn't inherently support the concept of running a job for a specific number of days and then stopping. Cron is designed to schedule recurring tasks at regular intervals.

If you want to run a job every day for up to 30 days, you could use the cron expression "0 0 * * *" to run the job every day at midnight. However, you would need to implement additional logic outside of the cron schedule to stop the job after 30 days.

This could be done, for example, by storing the start date of the job in a database or file, and then checking this date each time the job runs. If the current date is 30 days or more after the start date, the job could then stop itself.

Again, the exact implementation of this would depend on the system you're using to schedule and run your jobs.