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 Thursday, June 26, 2008 4:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 20, 2011 9:53 AM
Points: 11, Visits: 37
Hi All,

Does anyone know if it's possible to receive notification of failure AND success rather than one or the other??

Thanks
Bob
Post #524001
Posted Thursday, June 26, 2008 8:34 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
Bob,

Choose "When the job completes" if you want a notification regardless of whether it succeeds or fails.

Post #524235
Posted Thursday, June 26, 2008 8:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 20, 2011 9:53 AM
Points: 11, Visits: 37
God I really should have noticed that myself! Thanks a mil :)
Post #524247
Posted Sunday, July 20, 2008 3:19 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:14 AM
Points: 208, Visits: 442
takutoyamada (4/25/2008)
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?



I understand, you could send email to two or more people by :

@recipients=N'rinup@xyz.com';zbc@aby.com,---> delimit semi colan

:)
Post #537247
Posted Sunday, July 20, 2008 3:21 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:14 AM
Points: 208, Visits: 442
@recipients=N'rinup@xyz.com';'zbc@aby.com',---> delimit semi colan
forgot the quotes;)
Post #537248
Posted Tuesday, July 22, 2008 5:07 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
I believe what you are referring to is the Database mail- I know it allows multiple recipients, but what I'm having trouble with is the notifications for the failed jobs.
Post #538900
Posted Thursday, July 24, 2008 10:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 6, 2008 6:21 PM
Points: 52, Visits: 224
Has anyone had any luck getting this to work on a Lotus Notes Server?

It seems to only want to accept standard email addresses: somebody@somebody.com

Any suggestions?
Post #540334
Posted Sunday, July 27, 2008 12:45 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:14 AM
Points: 208, Visits: 442
todd_dawson (7/24/2008)
Has anyone had any luck getting this to work on a Lotus Notes Server?

It seems to only want to accept standard email addresses: somebody@somebody.com

Any suggestions?


Not sure about lotus notes, but it worked perfect with microsoft outlook!!
Post #541490
Posted Thursday, August 7, 2008 1:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 3, 2009 3:26 AM
Points: 1, Visits: 26
very useful post thanks a lot. if i keep the option as "when job completes". will it sends if the job success or fails. because there i didn't find multiple options for both job fails and job succeeds.my requirement is i have to send a mail to know is the job succeeded or failed.
Post #548607
Posted Thursday, August 7, 2008 1:41 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
ganta_sateesh (8/7/2008)
very useful post thanks a lot. if i keep the option as "when job completes". will it sends if the job success or fails...

Yes. Always a good idea to test for the expected results though. I'd suggest you do something to make the job fail and succeed to insure you're getting what you want for both conditions.
Post #548634
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse