topic Re: Job Scheduling Timeline issue in Data Engineering

Job Scheduling Timeline issue

Srujanm01 — Tue, 11 Feb 2025 18:12:05 GMT

I'm trying to schedule the job; I created the job and ran it manually it is successful but when I'm trying to schedule the job for every 14 days the date the scheduler takes it into a different date and I'm not able to understand why this is happening.

for example - This job for instance was created on the 6th and I scheduled it to run every 14 days, which would make the next run on the 20th. However, databricks says it will run it on the 15th

Can anyone help me here?
Thanks.

Re: Job Scheduling Timeline issue

MadhuB — Tue, 11 Feb 2025 18:56:22 GMT

@Srujanm01 Can you try the cron expression "0 0 0 1/14 * ? *"

It does

Run at 00:00:00 (midnight)
Every 14 days
On any day of the week
In any month

Refer to the below screens.

Let me know for anything, else mark it as a Solution.

Re: Job Scheduling Timeline issue

Srujanm01 — Tue, 11 Feb 2025 19:24:21 GMT

What if we want to run this job at 1 PM on the 14th day?

Re: Job Scheduling Timeline issue

MadhuB — Tue, 11 Feb 2025 20:01:41 GMT

can you try "0 0 13 1/14 * ? *"

Re: Job Scheduling Timeline issue

Srujanm01 — Tue, 11 Feb 2025 21:26:42 GMT

How can I know when the next scheduled run will be?
The cron syntax above has just mentioned the schedule as 1 PM every 14 days and it is not showing the next run date, how to know the next run date?

Re: Job Scheduling Timeline issue

Srujanm01 — Wed, 12 Feb 2025 16:11:49 GMT

@MadhuB

Any answer to this question - How can I know when the next scheduled run will be?
The cron syntax above has just mentioned the schedule as 1 PM every 14 days and it is not showing the next run date, how to know the next run date