SQL job fails when I schedule DTS through job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » SQL job fails when I schedule DTS through job...

SQL job fails when I schedule DTS through job

Rate Topic

Display Mode

Topic Options

Author

Message

kanya.venkatappa

Posted Friday, September 16, 2011 12:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:00 AM
Points: 5, Visits: 26

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.

Post #1176208

Greg Charles

Posted Friday, September 16, 2011 9:02 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:14 PM
Points: 4,009, Visits: 4,891

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

Post #1176459

kanya.venkatappa

Posted Monday, September 19, 2011 3:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:00 AM
Points: 5, Visits: 26

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.

Post #1177145

kanya.venkatappa

Posted Tuesday, September 27, 2011 3:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:00 AM
Points: 5, Visits: 26

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 ?

Post #1181596

handkot

Posted Tuesday, October 11, 2011 8:00 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:32 AM
Points: 1,032, Visits: 436

turn on logging in the package

Post #1188458

« Prev Topic | Next Topic »

Permissions