Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL job fails when I schedule DTS through job Expand / Collapse
Author
Message
Posted Friday, September 16, 2011 12:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, September 16, 2011 9:02 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 4,065, Visits: 5,298
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
Posted Monday, September 19, 2011 3:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, September 27, 2011 3:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 11, 2011 8:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:24 PM
Points: 1,328, Visits: 470
turn on logging in the package
Post #1188458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse