Hi @Ismail Cassiem ,
Please check if you missed some steps when setup SQL Server alerts and email operator notifications.
- Setup SQL Server Database Mail
- Define a SQL Server Operator
- Setup SQL Server Agent Settings
- Restart SQL Server Agent to Activate Settings
- Define a SQL Server Alert
6.Verify SQL Server Alert is Working
Please refer to the blog How to setup SQL Server alerts and email operator notifications to get more detail steps.
Best regards,
Cathy Ji
If the response is helpful, please click "Accept Answer" and upvote it, thank you.