Hi All,
I have a DTS package which runs a stored proc, copies the result in an
xls and mails the xls to me.
The package runs fine when executed manually, but when it is scheduled
as a job, it seems to hang.
After some testing I found that it hangs at the 'Mail Sending' part.
If the Send Mail task is removed, the package job runs perfectly fine.
I tried testing the SQL Mail profile, but that too seems to hang.
Does anybody have any idea why this is happening?

Any pointers to this would be greatly appreciated!!

Hello snigs,

There is a huge amount of difference between a package that executes as a
job and one that is executed interactively. Most of the differences pertain
to location and permissions.

Have a read of this

http://support.microsoft.com/?kbid=269074

Allan