DTS that keeps running

[rsbutterfly16]

hi , i was wondering if you can help me, i have several dts jobs in my sql server. I have set them up to that if they fail to send me an email. Is there any way to set them up to send me an email if they run or freeze for a long time? for example from time to time i have this DTS that for some reason it runs for hours instead of what it usually takes 3 minutes, i would like to be informed when this happens.

What would be the best way to go about this?


Thanks in advance

 

[SQLSister]

I get a start email (first task in the DTS package) and a finished email (last task). If I get a start email and don't get a finished email in the time I usually get it, I start looking as to why. In your case since it normally runs fast, I would suspect some other process running at the same time is blocking it when it slows down.

Questions about posting. See faq183-874