Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alerts Setup but no Email is sent to Notify operators?

Status
Not open for further replies.

katekis

MIS
Feb 12, 2009
66
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top