Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

SQL Server 2005 Job email notification alerts Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2008 10:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Tuesday, March 18, 2008 11:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
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
Posted Wednesday, March 19, 2008 9:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, April 25, 2008 12:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 4, 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
Posted Friday, April 25, 2008 3:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, April 25, 2008 3:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 4, 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
Posted Friday, May 2, 2008 2:00 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:48 PM
Points: 755, Visits: 1,568
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
Posted Friday, May 2, 2008 2:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
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
Posted Wednesday, June 4, 2008 2:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 5, 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
Posted Wednesday, June 4, 2008 2:37 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
jenelle.hilemon (6/4/2008)
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?

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 »

Add to briefcase 12345»»»

Permissions Expand / Collapse