SQL JOB (DTS PACKAGE) NOT RUNNING.
-
Guys, We've got a problem. There is a DTS package which polls for a file and puts it into a ..\Processing directory. It is written as an ActiveX Script. It refuses to run as a scheduled job. However, if you execute it, it runs perfect. There are no other jobs running that would interfere with this one. Indeed, no other jobs running even close to that time at all. To add to this: when you look in the job history, it always shows that the job failed - even when you manually run it and it is in fact succesful. We have tried to delete the DTS and the job and re-create them from scratch. However, the same problem persist. We would not like to re-create the DTS package and the job under a different name (that worked before for other problem, BUT: it would break the standards, as over 100 clients have that DTS installed and scheduled, and it works fine with them!) Is that a Microsoft bug or something? It looks like somewhere it has recorded that this package name does not work! Any help is appreciated. Best Bigfootguy
-
Guys, We've got a problem. There is a DTS package which polls for a file and puts it into a ..\Processing directory. It is written as an ActiveX Script. It refuses to run as a scheduled job. However, if you execute it, it runs perfect. There are no other jobs running that would interfere with this one. Indeed, no other jobs running even close to that time at all. To add to this: when you look in the job history, it always shows that the job failed - even when you manually run it and it is in fact succesful. We have tried to delete the DTS and the job and re-create them from scratch. However, the same problem persist. We would not like to re-create the DTS package and the job under a different name (that worked before for other problem, BUT: it would break the standards, as over 100 clients have that DTS installed and scheduled, and it works fine with them!) Is that a Microsoft bug or something? It looks like somewhere it has recorded that this package name does not work! Any help is appreciated. Best Bigfootguy
OK now. The error was in Scheduling a Job: the Step should have been of type Operating System Command (CmdExec), NOT Transact SQL Script (TSQL), as the DTS package itself is ActiveX VB Script. The problem has been resolved. Best Bigfootguy