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 |
|
elomon
Starting Member
37 Posts |
 Posted - 2002-07-12 : 11:37:48
|
| I've made a DTS package that imports some tables from an Oracle db. If I right click on the DTS package, Execute Package, it executes sucessfully.Then I right click on package, hit schedule. Then right click on job, hit start, it runs and reports sucessful but no work is done. I've checked the Job to ensure the package is in there & it's executing as NT Admin account. I've made sure the job reports failures as failures & sucess as success.So, if I execute it as DTS, it works, as job with DTS as a step, reports successful but no work done. Server is running Win 2K SP2, SQL 2K Enterprise. Any ideas much appreciated. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-12 : 11:53:42
|
| Well, keep in mind that when you 'play' a pkg from you desktop it runs on you local machine. When you run as a job is runs on the database server. Maybe you have some permissions issue between your SQL Server and Oracle box? Just a wag.<O> |
 |
|
|
elomon
Starting Member
37 Posts |
Posted - 2002-07-12 : 12:17:59
|
| Hmm, I'm new to DTS so maybe I misunderstand. I'm not doing anything from the desktop. I can Execute Package from SQL Enterprise Manager, have not tried executing it remotely. This behavior occurs when I am sitting at the database server, so permissions should be the same. |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-12 : 13:55:35
|
quote:
Well, keep in mind that when you 'play' a pkg from you desktop it runs on you local machine.
You can tell it which machine it runs on though. I got ones I run from my machine but it affects the main server here.Do remember That the job is being executed by sql Server Agent... Make sure it is logging into an account with appropriate permissions-----------------------Take my advice, I dare ya |
|
|
|
|
|
|
|
|
DTS Job Successful but DTS not run