August 28, 2002 at 1:26 pm
I created a DTS package that executes and completes successfully when run manually. I scheduled the job to run at a certain hour of the day. I can see that the package completes, but the job does not stop executing. I can see that the package completes cause it creates certains files. The job continues to execute until I kill the process. Is there a trick to get the job to stop when the package has completed ?
Thank you.
August 28, 2002 at 2:50 pm
Try dropping the job and recreating, may be a permissions issue. DO you have any code checking at the end the process was successfully in the DTS or job itself. If so and it looks at the files then it may be locking itself from the files due to permissions or some other reason.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 28, 2002 at 2:50 pm
No, it should stop ok. Usually when odd things happen its permissions, running from a job is usually a different account than when you run manually.
Andy
August 29, 2002 at 6:56 am
I don't think it is permissions cause the job executes. It successfully picks up files from one directory and puts them in another directory. It just doesn't stop executing when there are no more files to move. When the DTS package is run and there are no more files to move I get the message "Successfully completed the execution of the package". It is as if the job keeps executing yet the DTS package has completed. I say that cause new files placed in the directory are not moved even though the job is still executing.
I am the owner of the DTS package. When the job is created it has 'sa' as the owner.
Any other ideas ?
August 29, 2002 at 7:41 am
You might try adding logging or an error fil by openin the properties of the package and setting these. Shoul be able to tell you where the process stopped or if ran to finish. Also make sure steps and process have a description so you can identify them when you look at the log/file.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply