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.
You would need two alerts, one with a cron expression for Saturday hours and another for Sunday hours.
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.
r. Ismo