How do we handle an alert that needs to run on certain hours on Saturday and on different hours on Sunday. Can the cron expression express something like that?
We ended up placing the scheduling logic in the query itself.
As @ITWhisperer already said, the common way to do it is add as many “alerts” as needed with own schedules. Query should be the same, but probably it’s easier to add earliest+ latest to it than trust those which are on alert definition.
