Jay,

Ensure the profile name in the send mail task in your DTS package is the same profile being used via SQL Server Agent.

When you run the package manually it uses...