I have a SQL job (SQL 2000) which runs the DTS (FTP the file) . When scheduled through job, it fails. But if I manually re-run the job, it runs successfully.
Here is the job history :
The job failed. The job was invoked by schedule 48. The last step to run was step 1(pull file from interface team through DTS)
Note : SQLServer agent is running under N account. The job is also running under same ownership of N account.
Any help will be much appreciated.
Thanks in advance.