Manually setting alert times

Get Help
1

I’ve been having problems with alerts not sending. I thought it was transforms that were refreshing materialised views, but still happening after disabling them.

While investigating, I’ve found the notification_subscription table that contains all the subscriptions and their schedules.

The schedules are just standard cron syntax, so it should be possible to change them manually to run at slightly different intervals to those available in the UI.

Before I break my customer’s server, has anybody else tried this?

2

do you see any logs when the alerts don’t send?

3

The alerts not sending are in a separate thread. Looks like it’s due to long running queries. Solving by checking my customer’s query performance and tweaking the DB.

For the Cron syntax, it didn’t run yesterday but I don’t know when the information is passed to Cron. Fingers crossed for 1215 today!