Job Scheduling Timeline issue

[Srujanm01]

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.

[MadhuB · Accepted solution]

@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.

[Srujanm01]

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

[MadhuB]

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

[Srujanm01]

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?

[Srujanm01]

@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