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 |
|
smeeluv
Starting Member
20 Posts |
 Posted - 2009-11-23 : 17:18:35
|
| Anyone else have this problem. I have a package that calls a command to zip a file from Winzip32 and it runs fine in debug but when I run through SQL Agent, it basically times out and doesn't finish. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-11-23 : 17:55:09
|
quote:
it basically times out and doesn't finish.
That doesn't make sense. Do you get a time-out error?What is the command you are using? Are you using the command-line version of winzip?Is it possible the command is waiting for user input? But you don't see that screen. |
 |
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-11-24 : 08:29:01
|
| Well, it doesn't time out but the process in debug takes about 15 minutes and the job through SQL Agent was going over 2 hours with no changes. The command I am using is:-min -a -en "D:\test.zip" "D:\test.mdb"It's zipping test.mdb. I do not believe it is waiting for any input, I will run it in debug againg and see what happens. |
|
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-11-24 : 15:31:26
|
| I got it going now. It will not run under the system user so I created a new proxy to run it under and it runs fine now! |
|
|
|
|
|
|
Process Task will not run through SQL Agent