Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinurvk
Starting Member
8 Posts |
 Posted - 2010-12-08 : 04:37:30
|
| Hi All,I want to trigger an success email and failure email when an SQL Task gets completed or failed.I have 3 tasks created and mapped as below.Task1 (SQL Task) > On Completion > Task2 (SQL Task) - this task triggers an email stating that "Task 1 is completed successfully"SimilarlyTask1 (SQL Task> On Failure > Task3 (SQL Task) - this task triggers ann email stating "Task 1 failed".However, I see that only the Task 2 gets executed upon Task1's success execution by triggering an email. But when the Task1 fails there is no mail gets triggered by executing Task3.Please let me know how to get this accomplished. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2010-12-08 : 10:54:12
|
| I don't have an answer to your problem however if you look at http://www.sqldts.com you may find something useful-----------I used to think I wasn't a morning person but it never got better in the afternoon |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-08 : 12:53:55
|
| Change on completion to on success |
|
|
|
vinurvk
Starting Member
8 Posts |
Posted - 2010-12-09 : 10:10:18
|
| Any help with my request will be much more helpful.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 10:19:12
|
| Did you try what I suggested? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-09 : 10:23:03
|
Have a look at your Task1 workflow properties.Maybe there is selected to fail the package if this task fails.I believe in this case the package is failing without executing Task3.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 10:25:25
|
| I think the problem is he has Task 2 set to run regardless of the outcome of Task 1.On completion is not the same as on success.Not sure why he didn't try it before saying the post wasn't helpful.But you're right Fred, it could be failing the entire package in step 1. Still, the answer I gave ought to solve it. |
|
|
|
vinurvk
Starting Member
8 Posts |
Posted - 2010-12-22 : 12:10:06
|
| thanks guys.. it worked.. |
|
|
|
|
|
|
Help with DTS Package