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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics