Invalid CRON expression cron(* ? * * * *)

[zsidez]

Is this a valid cron expression? cron(* ? * * * *)

EventBridge's Define schedule shows error: Invalid CRON expression

Latest version (v4.0.2) of Security Automation still have this setting

Originally posted by @zsidez in #186 (comment)

[abewub]

Thanks for reporting. Will be fixed in the next release.

[aijunpeng]

@zsidez cron(* ? * * * *)defines a job that runs at the top of the hour. How did you get the error? Please provide steps to reproduce.

[zsidez]

@aijunpeng This is how it will be at the beginning of the hour: cron(0 * ? * * *) or cron(0 * * * ? *)

Can't put question mark ? at any position. Allowed only for Day-of-month and Day-of-week

To reproduce can open created(or create new) events bridge rule in aws console:

EventBridge's Define schedule shows error: Invalid CRON expression

[zsidez]

[zsidez]

Also I suggest to run this add_athena_partitions job not at the top of the hour. But every minute. To be sure that partition is created.

Current code that adds partition already doesn't add it if partition exists: ALTER TABLE ... ADD IF NOT EXISTS PARTITION . So every minute should work

So cron can be: cron(* * * * ? *)

[aijunpeng]

Thanks for providing more information. I've validated that cron(* ? * * * *) works fine in CFN template. So if you deploy the solution template, there won't be an issue. However for some reason (could be due to some service change) it doesn't work on AWS console any more. If you want to update the expression via the console, please enter the correct cron expression to pass the error. We have added this issue to our backlog and will address it in future release. I am not experiencing any problem with running hourly query to add hourly partition on my end though.