Okay I give! I am trying to set up Database Mail in SQL Agent......no big deal, right? Wrong!
I have a public, default profile configured under Database Mail that sends a message when you send a test message. I can send a message using sp_send_dbmail without a problem. So mail should be configured properly, right?
Down in Sql Agent, I enabled email profile, selected database mail and selected the default, public profile above. Everything seems okay, except the Test button is grayed out. Hmmm! When I try to set an email notification on a job, I am unable to create a new operator. In fact, I have a blank dropdown button. I have stopped/started the Agent service repeatedly, and even rebooted the server just for grins. Still no test button, and still no ability to create a new operator.
Something is amiss somewhere, but I'm out of ideas of what else to try!