Tableau 10 added with refresh fail alert mail option.
If you want to get alert mail then create google group and add that mail id in that user mail.
This doesn’t answer my question unfortunately. The article only says that the owner of a data source and the workbook publisher get email notification. How can I set the alert to go to more than two people? ‘Both the owner of the published data source as well as the owners of published workbooks containing that data source will be notified’