Too many emails with notifications

[Franz]

Hi there, i have a problem with email notification because of my stupidity... I have used the libzbxpgsql template without disabling some triggers and stuff and after one weekend it sent me like few hundred thousand email notifications and it is still sending new ones. I disabled the template on monday this week and its friday already and i keep getting new notifications.... I assume there might still be a lot of them cached in the database but i don't quite know where they are stored.... Could you please guide me where to look for those in the database ? And if you ever had a similar problem or just have any idea how to stop this email flood i would be thankful for any advice.

Im using Zabbix 3.2.4

[LenR]

What is the timestamp on the latest notification? If it's old, they messages might be in the mail queues waiting for delivery.

If they have current time, then the checks aren't really disabled. My common mistake is to unlink instead of unlink and clear.

[Franz]

Well, i have disabled the host that template was linked to, almost all triggers, discovery rules, items, and whatever i could disable leaving only 2 or 3 things that i rly wanted to have in the first place. Unfortunately my friend unlinked the template so im not 100% sure if he unlinked and cleard or only unlinked, but lets assume he did the clearing option [i will do it again on monday just in case but lets assume for now]. Shouldnt disabling the host be enough to stop zabbix from sending those emails ? Emails have current timestamp regardless i have disabled everything so i think those notifications might be cached somewhere in the database ? I just dont know where to look for them :/