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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-28 : 08:38:25
|
| Alim writes "I have a DTS package that has to run every morning, it is just one ActiveX script. It runs fine when I select "Execute Package". It even runs fine when I schedule the package and it executes at the right time and succeeds. The problem is, when I go to the "Jobs" under the "Management" folder and try running the job manually (by selecting "Start Job"), it does not work. The status says, its running, and I guess it just gets stuck there. I have to manually stop the job for it to end. To give you an idea how long it gets stuck, when the scheduler kicks off the job, its succeeds in 2 seconds, when I try to manually start the job, it didn't succeed even after 3 minutes. If someone could give me an explanation why this is happening it would be greatly appreciated.Alim." |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-28 : 16:17:50
|
quote:
Alim writes "I have a DTS package that has to run every morning, it is just one ActiveX script. It runs fine when I select "Execute Package". It even runs fine when I schedule the package and it executes at the right time and succeeds. The problem is, when I go to the "Jobs" under the "Management" folder and try running the job manually (by selecting "Start Job"), it does not work. The status says, its running, and I guess it just gets stuck there. I have to manually stop the job for it to end. To give you an idea how long it gets stuck, when the scheduler kicks off the job, its succeeds in 2 seconds, when I try to manually start the job, it didn't succeed even after 3 minutes. If someone could give me an explanation why this is happening it would be greatly appreciated.Alim."
I believe the latest service pack might help.setBasedIsTheTruepath<O> |
 |
|
|
|
|
|
|
|
Manually running scheduled DTS jobs