February 11, 2003 at 10:38 am
Hi all. I have a DTS Package that reads a text file's first line and check's to see if the first line has the correct date through a series of functions to check holidays, weekendds, etc. When it does not, I have it use a Send Mail task on failure so our department knows the unit values have not yet been updated. When executed from DTS Designer, this works as it is supposed to, but when scheduled as a job, the Send Mail task fails due to a MAPI Logon error. Any idea how to fix this? My boss wasn't exactly pleased something I told him would work, did not function properly, and so no one recieved warning. Any help here would be great. I assume it's some sort of security context setting. Has anyone else ran into this and fixed it? Thanks.
February 11, 2003 at 10:48 am
I think the problem is that when the DTS package runs within a job is does with the security context of the SQL Server Agent Logon account. You should use a mail profile with the same domain account of the SQL Agent login account.
February 11, 2003 at 11:21 am
Yes, and just to addd to Rodrigo's post, you will always want to execute the DTS package and job at the server its going to run on as the NT user who runs SQL Server Agent as a test just to make sure that its going to run.
We've been burned by this several times.
-JB
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply