SQL job fails when I schedule DTS through job

• kanya.venkatappa

  SSC Journeyman

  Points: 85

  More actions

  September 16, 2011 at 12:19 am

  #257389

  Hi Guys,

  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.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 16, 2011 at 9:02 am

  #1382597

  This is usually a permissions problem. Does the N account that SQL Agent runs as have the required file permissions on the FTP location?

  Greg

• kanya.venkatappa

  SSC Journeyman

  Points: 85

  More actions

  September 19, 2011 at 3:53 am

  #1383209

  Thanks Greg.

  N-account was not added to FTP location. I have given full control to N-account on FTP folder.

  Lets wait for scheduled run tomorrow.

• kanya.venkatappa

  SSC Journeyman

  Points: 85

  More actions

  September 27, 2011 at 3:52 am

  #1387012

  Hi Greg,

  Giving full control to N account for the FTP folder didn't work. Job has continued to stuck every alternate day.

  Previously job used to take 4min to run but now it is taking 30min to run.

  Could you please suggest ?

• handkot

  SSCertifiable

  Points: 5181

  More actions

  October 11, 2011 at 8:00 am

  #1392868

  turn on logging in the package

  I Have Nine Lives You Have One Only
  THINK!