I have multiple SQL Servers. On each of the SQL Servers I have Alerts setup. One of them is for Insufficient Permissions.
I am using SQL Server 2005 SP3
On some of my SQL Servers if their is a login Failure the alert works just fine. The Notify Operators receive the Email saying Login Failure.
On a few of my ohter SQL Servers the Notification is NOT working and I can not figure out why.
The Alert, and Operators look like they are setup exactly the same on each server but for some reason the Alert does not work?
I had been using a Job Monitoring System (SQL Sentry). The alerts only work if I Execute Job and use the Job Monitoring System. We no longer want to use the Job Monitoring System. On some servers the alerts work fine but on other servers it does not.
Any ideas what maybe wrong and why alerts are not sent Notify Operators?
I am using SQL Server 2005 SP3
On some of my SQL Servers if their is a login Failure the alert works just fine. The Notify Operators receive the Email saying Login Failure.
On a few of my ohter SQL Servers the Notification is NOT working and I can not figure out why.
The Alert, and Operators look like they are setup exactly the same on each server but for some reason the Alert does not work?
I had been using a Job Monitoring System (SQL Sentry). The alerts only work if I Execute Job and use the Job Monitoring System. We no longer want to use the Job Monitoring System. On some servers the alerts work fine but on other servers it does not.
Any ideas what maybe wrong and why alerts are not sent Notify Operators?