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

Email notification on individual job steps Expand / Collapse
Author
Message
Posted Thursday, January 20, 2011 11:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 28, 2014 6:57 AM
Points: 10, Visits: 158
How can I have Sql Server 08 notify me when step one has completed successfully. I don't have to have to open up MStudio to check it. I would like to know that it is successful with this manual step. Can I add it to the bottom of the step?
Post #1051047
Posted Thursday, January 20, 2011 11:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
You could add a step in between 1 and 2, that sends an e-mail to you.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051054
Posted Thursday, January 20, 2011 11:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 28, 2014 6:57 AM
Points: 10, Visits: 158
Wow, that was too simple. I've been looking at this package for hours. What is the best method for sending the email from the step? CmdExe, powershell?
Post #1051074
Posted Thursday, January 20, 2011 11:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Since you're posting in the SQL 2000 forum, I'm assuming that's what you're using. It's been WAY too long for me, and I don't remember the options in there.

If it's actually 2005/2008, then DBMail is the easiest.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051075
Posted Thursday, January 20, 2011 11:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 28, 2014 6:57 AM
Points: 10, Visits: 158
Thanks. You have been extremely helpful.
Post #1051081
Posted Friday, January 21, 2011 7:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
You're welcome.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051530
Posted Friday, January 21, 2011 10:09 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:27 PM
Points: 4,064, Visits: 5,327
ckingtaylor (1/20/2011)
Wow, that was too simple. I've been looking at this package for hours. What is the best method for sending the email from the step? CmdExe, powershell?


If using SQL 2000, use xp_sendmail. If SQL 2005/2008, use sp_send_dbmail.


Greg
Post #1051676
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse