topic How to schedule job in workflow for every 30 days in Get Started Discussions

How to schedule job in workflow for every 30 days

pcbzmani — Tue, 04 Jul 2023 05:57:34 GMT

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 * *

Re: How to schedule job in workflow for every 30 days

Vinay_M_R — Tue, 04 Jul 2023 06:41:43 GMT

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.

Re: How to schedule job in workflow for every 30 days

pcbzmani — Tue, 04 Jul 2023 06:57:53 GMT

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.

Re: How to schedule job in workflow for every 30 days

Vinay_M_R — Tue, 04 Jul 2023 07:38:07 GMT

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.

Re: How to schedule job in workflow for every 30 days

Aviral-Bhardwaj — Tue, 04 Jul 2023 08:41:21 GMT

use this website https://crontab.guru/ , here you will get good idea

Re: How to schedule job in workflow for every 30 days

VaibB — Tue, 04 Jul 2023 11:39:04 GMT

You could go to the crontab and set the expression as 0 0 */30 * *

Re: How to schedule job in workflow for every 30 days

pcbzmani — Tue, 04 Jul 2023 13:45:34 GMT

This is not working. Getting Invalid Quartz Cron Expression

Re: How to schedule job in workflow for every 30 days

Tharun-Kumar — Wed, 12 Jul 2023 05:05:35 GMT

@pcbzmani

Could you try 0 0 0 1/30 * ? *

Databricks uses Quartz cron syntax and we have to provide 1/30 for day to achieve a schedule for 30 days.