SQL Server Agent Problem

[annenarne]

Hello,

I have a problem while scheduling a DTS package (import of data from as/400 to SQLServer 7). I made the package and it runs without problem when I start it manually. But when I make a job to run it at night, it fails. Maybe something wrong with the sql server agent ? The error tells me something about the 'tnsrun' command that I use, but I don't think that is wrong. Is there someone who has some experience in importing data from as/400 ?

Thanks,
Ann

 

[tlbroadbent]

Jobs run under different security when started by the agent than when started in Enterprise Manager manually. Check the article about "How to Run a DTS Package as a Scheduled Job" at

http://support.microsoft.com/support/kb/articles/Q269/0/74.ASP.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.