Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dancewav
Starting Member
9 Posts |
 Posted - 2001-11-25 : 09:58:17
|
| ok ,I know there have been a few posts about running DTS under jobs (i.e. sql server agent but I can't get this to work) What I have done is create a DTS ON the Server (not workstation) it basically copies data out to a novell server into a foxpro table, it works fine from the server from the enterprise manager, but under the scheduled job it doesn't work , the error file reports invalid file location (UNC is used) i.e. \\server\dir\table, it can't see the server, we have tried logging the agent in as the same user as myself, i.e. (god like admin rights) but it wont find the server / directory , I hope someone can offer ANY kind of help please, even a guide to loggin the agent in as admin , like I say it was developed on the server and runs on the server but not under server agent (scheduled job) am I being thick ? help me obi wan you are our last chance - princes leia. any help please |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2001-11-27 : 14:15:11
|
| try loggin into the server using the account that the SQL Server Agent uses to start and run with. While logged in as that user, make sure you can get to your UNC path and try running the job from EM.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
DTS under scheduled jobs again - but differen't ?