I’m trying to update a report so it gets sent every weekday. I see I need to use quartz cron syntax. I’ve tried various ways to to type in my data but it won’t take. Can someone help me? I want to schedule every weekday at 8 AM for example
I haven’t tested this in Metabase, but using this cron quartz expression generator emits this selector for your pattern:
0 0 8 ? * MON,TUE,WED,THU,FRI *
Thanks for the feedback Doug! Yeah I tried that but I get this:
Our quartz cron syntax is a string of 5 fields, starting from minutes, separated by spaces
Invalid cron expression
Oh, Metabase drops the seconds. Remove the first zero.
Drop the last * then. Sorry, should have tested this first.
Aha! That worked! Thank you SO much! I’ve been fighting this for a while now, I really appreciate it!
For anyone landing here later: same thing in shorter form is `0 8 ? * MON-FRI`. Metabase's parser is the 5-field cron variant (no seconds, no year), which is the usual source of the "Invalid cron expression" error.