send mail task failing the whole task
I have a GrandMaster, there are master1, master2, master3 are invoked in GrandMaster. In Master1,Master2 and Master3, there are a few 'Execute Package Task' say for example SubPackage1,SubPackage2,SubPackage3 are executed in Master2. SubPackage4,SubPackage5,SubPackage6
are executed in Master2 and SubPackage7,SubPackage8,SubPackage9 are executed in Master3.
Currently I have a lot of notification steps are running at Master1, Master2 and Master3. And I also have a lot of notification steps are running in SubPackage1 to SubPackage9. These notification are SendMail task that send the ETL progress report to group
of users. These notification steps may not always run in the end of each package.
My requirement: I do not want to fail run if errors coming from Send mail tasks. If Sendmail tasks fail to run, all the following steps should continue to run.
How can I do it? Thanks
Tgnaxin
January 24th, 2011 6:24am
For the case where these are not the last task what you could do is set the precedence constraint value to "Completion" rather than the default success(green arrow). Double click the precedence constraint and do the above changes.
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 4:22am
Hi,
You can set the connector between the task to "Completion" instead of "Success". Or you can set the MaxError to 0 or a large number but it will require some efforts to handle these errors. Like using variables for Email parameters and use them as output
into your error path
Regards
Regbac
January 25th, 2011 9:18am
Thanks Sudeep and Regis.
I've tried to move the notification as the end of each package so I can use "Completion" to link these packages.
Tgnaxin
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 11:01pm