467,915 Members | 1,280 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

SQL Server Agent Alert System - Operators?

SQL Server 2005 SP2 64-bit

I am quite confused about the SQL Server Agent Alert System.

I have configured Database Mail, establishing my Profile(s) and
Account(s), and specifying SMTP server+port. I then configured SQL
Server Agent, under Properties->Alert System, to use Database Mail,
specifying a particular Mail Profile to use.

I then go into the properties of one of my Agent Jobs, and under
Notifications, expect to see, perhaps by default, the Database Mail
profile I picked when configuring Agent, or perhaps an account under
that particular profile.
Instead I have to pick an Operator. What do Operators have to do w/
the accounts/profiles in Database Mail? Shouldn't Database Mail have
made Operators unnecessary and obsolete?

When I define an Operator, I only specify an e-mail address, not an SMTP
server or port. How does it know the server/port to use? Does it
use those defined under Database Mail? If so, what account?

Can someone explain this to me?


Sep 18 '08 #1
  • viewed: 2198

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

42 posts views Thread by scorpion53061 | last post: by
reply views Thread by Suresh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.