SQL Server 2005 Job email notification alerts

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » SQL Server 2005 Job email notification alerts...

53 posts, Page 1 of 6

1 2 3 4 5 »»»

SQL Server 2005 Job email notification alerts

Rate Topic

Display Mode

Topic Options

Author

Message

Claudia-343424

Posted Tuesday, March 18, 2008 10:52 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, March 21, 2009 12:49 PM
Points: 50, Visits: 64

Hi there, I was wondering if somebody could tell me how to configure the notification alerts on a job properties. Basically I want to receive an email when a job is completed or is failed.
Thanks

Post #471017

Todd Engen

Posted Tuesday, March 18, 2008 11:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 11:02 AM
Points: 1,073, Visits: 6,321

In SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a test mail using the new profile to confirm that works.

Next, open the properties of the SQL Server Agent. On the Alert System page enable the mail profile. Restart the SQL Server Agent for the change to take effect.

Under the SQL Server agent create Operators to send messages to.

Finally, in your job select Notifications and set the Operator to send to when the job completes.

Post #471075

Claudia-343424

Posted Wednesday, March 19, 2008 9:54 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, March 21, 2009 12:49 PM
Points: 50, Visits: 64

Thank you so much it worked!
Claudia

Post #471679

takutoyamada

Posted Friday, April 25, 2008 12:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 04, 2010 10:46 AM
Points: 8, Visits: 56

A clarification question. Upon a failed job, I want to send an email to 2 different email addresses. So, I created 2 operators and checked them to receive emails in the Response of the alert properties.

However, in the Notifications in the Job properties, it only enables you to select one operator to send an email upon the completion of the job. So, I'm confused about how alerts and notifications work.

It seems that the alerts have all the information it needs to send out the emails, but then if you don't turn on the Notifications, the email is not sent. I tested this by disabling the email in the job under notifications, and left the alert configured to send emails to 2 operators. Upon running the job from this step, and getting a failure, there was no email sent. Am I missing something on how alerts work?

Post #490881

Claudia-343424

Posted Friday, April 25, 2008 3:13 PM

Valued Member

Group: General Forum Members
Last Login: Saturday, March 21, 2009 12:49 PM
Points: 50, Visits: 64

I created a distribution list and used that email. As far as I know just one email address.

Post #490960

takutoyamada

Posted Friday, April 25, 2008 3:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 04, 2010 10:46 AM
Points: 8, Visits: 56

Thanks-

As a workaround, I added the pager email for the other admin, changed the on-call times to be 24x7, and had it send to the pager for the other admin, since you can't choose 2 email recipients.

It would be nice if the difference between alerts and notifications were more clear.

Post #490967

Jpotucek

Posted Friday, May 02, 2008 2:00 PM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:56 AM
Points: 718, Visits: 1,470

Maybe you can help me too.. I did all this:

n SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a test mail using the new profile to confirm that works.

Next, open the properties of the SQL Server Agent. On the Alert System page enable the mail profile. Restart the SQL Server Agent for the change to take effect.

Under the SQL Server agent create Operators to send messages to.

Finally, in your job select Notifications and set the Operator to send to when the job completes.

but when I click on sql server agent properties to send a test mail, I can choose my operator but the send test tab is greyed out????

Post #494533

Todd Engen

Posted Friday, May 02, 2008 2:29 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 11:02 AM
Points: 1,073, Visits: 6,321

Could be wrong, but that Test button in the Agent properties looks to be for SQLMail only. I checked on a SQL 2005 SP2 and SQL 2008 CTP instance; greyed out on both when Database Mail is selected, active with SQLMail.

You should be able to test Database Mail from its context menu though.

Post #494549

jenelle.hilemon

Posted Wednesday, June 04, 2008 2:27 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 05, 2012 11:51 AM
Points: 20, Visits: 21

Did you use Microsoft Outlook to create the list? Does Outlook have to be installed on the server that your trying to create the notification on? I have tried to do this with no luck...can you explain how you did it?

Post #511774

Todd Engen

Posted Wednesday, June 04, 2008 2:37 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 11:02 AM
Points: 1,073, Visits: 6,321

jenelle.hilemon (6/4/2008)

No, Outlook does not have to be installed on SQL if Database Mail is being used.

Reference:
How to create a distribution list (distribution group) in Exchange Server 2003

Post #511777

« Prev Topic | Next Topic »

53 posts, Page 1 of 6

1 2 3 4 5 »»»

Permissions