SQL Server Performance Forum – Threads Archive
DTS Failure notificationHi,
Is there a way where the DTS packages mails automatically when it fails.
I know the way where we use in DTS designer execute package and then on
failure use excute SQL task(within that xp_cdosysmail). Any easy way
other than that.
Thanks in advance
If the DTS is scheduled from SQLAgent, you can use SQLAgentMail.
When the DTS fails, the job can be configured to notify an operator via email, NET SEND, or pager