How to set up email notification in job - 2005

[sqlcasey]

Hi,

I am trying to set up an email notification on one of my jobs. However, I think I am missing something. When I check "email" as the notification format, there's a drop down box to the right, but it's blank and I can't add an email address in it, which I am assuming is what supposed to go in there.

When I click OK, and go back to check, the email box is not longer checked, so apparently my change didn't take.

Is there a trick to setting up an email address? DB mail is set up on the server, and sending a test email has worked.

Thanks

 

[ptheriault]

Have you run the database mail configuration wizard?

- Paul
- Database performance looks fine, it must be the Network!

 

[Catadmin]

You need to set up an initial DBMail profile (for the Server) and the email server it is pointing to. As ptheriault said, run the Database Mail Configuration Wizard.

Or open up Management, and right-click Database Mail, then follow the prompts.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

once you have set up database mail. Create an operator.
Open SQL Server Agent -> Right click Operators -> New operator Enter the name and email address for your operator. You will then be able to select the operator name from the job notification drop down.

- Paul
- Database performance looks fine, it must be the Network!

 

[sqlcasey]

yes, i already set up mail - i guess i am missing the operator, i will try that

 

[sqlcasey]

Hi,

Ok, I set up the operator (myself) and put my company email address in the email field.

I set up a job to send an email notification when the job succeeds, as a test. I ran the job, it succeeded.

However, no email was sent and there is no history of an email ever being sent in the operator history.

Is there an obvious problem here? Yes, mail is enabled on the server. I have successfully sent myself a test email to myself from the server earlier today.

???

Thanks

 

[ptheriault]

If you right click on Database Mail you can select the mail log. Are there any errors in there? Check the SQL Agent error log and the SQL Server Log. Do you see any errors?

- Paul
- Database performance looks fine, it must be the Network!

 

[sqlcasey]

Hmmm, at 9:45 am today it says that the "DatabaseMail process is shutting down"

1.) why would it shut down?

2.) how can i start it up?

Thanks!

 

[sqlcasey]

I should add, I just sent myself another test email and it worked, even with the above error msg. So obviously it CAN send emails, it just isn't send them via notifications for some reason

?

 

[sqlcasey]

Ok, the problem was this, I discovered on another board.

Restart the agent

Now it works!