MS SQL Server DTS - mail notifiactions not sent on success or on failure

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

mail notifiactions not sent on success or on failure

Andre Gibson

2006-01-20, 9:23 am

I have a dts which I am using to copy a db from the production server to the
backup server. I used the "copy sql sever object task" to copy the db.
Initally I had a problem with the views because the system was trying to copy
a view that called another view that the system had not yet created. To get
around this I added an "Execute Sql task" which ran (after the copy sql
server object task failed)the sql to recreate the views in the correct order.
That all now works, but at the end of the process I set up 2 email
notifications one for failure and one for success. They never get executed.
Can anyone explain this?

thanks

Sponsored Links