Spring Cron syntax in Backup schedules

Hi all,

Reading Spring Cron syntax documentation I understand question mark (?) is only available to be used to specify something in two fields in which the character is allowed.

What are the positions (fields) where the question mark is allowed?
I understand one is “day of the week” and I’m guessing the other is “day of the month”.

Also, I want to use it to set backups every first Sunday of the month.
I think the correct solution is: 0 0 0 ? * 1

Am I right?

Thanks a lot for your time.

Former User

Posted 5 years ago · Edited 1 year ago·Last reply 5 years ago

5 comments

Former User

OP5 years ago · Edited

umit.bhargava.rabobank.com:

0 0 0 ? * 1#1 *

I used 0 0 0 ? * SUN and it worked.

Thank you

Former User

OP5 years ago · Edited

Great it works for you but just a note 0 0 0 ? * SUN would be every Sunday and not just the first Sunday

Former User

OP5 years ago · Edited

Why not just use https://www.freeformatter.com/cron-expression-generator-quartz.html or any other online tool to make the desired CRON job.
By the way CRON JOB for first Sunday for every month would be 0 0 0 ? * 1#1 *

Former User

OP5 years ago · Edited

Hi @umit.bhargava.rabobank.com

Thank you for the tip. I was not familiar with CRON syntax.
Unfortunately that Cron syntax does not work in Collibra. Can it be because it has more than 6 positions?

Former User

OP5 years ago · Edited

This definitely should work.

More than 6 positions doesn’t matter as such. I have used one such cron in collibra for a subscription workflow already.