January 20, 2011 at 11:21 am
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?
January 20, 2011 at 11:27 am
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
January 20, 2011 at 11:44 am
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?
January 20, 2011 at 11:47 am
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
January 20, 2011 at 11:57 am
Thanks. You have been extremely helpful.
January 21, 2011 at 7:36 am
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
January 21, 2011 at 10:09 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply