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 |
|
khana04
Starting Member
4 Posts |
 Posted - 2009-03-30 : 16:17:57
|
| I havea simple DTS package which execute a .bat file on local server EXECUTE PROCESS TASK has the content belowD:\datafiles\tab\PushData.batPushData.bat has the following content, its basically delete bunch of files and than zip them using alzip utilitydel D:\datafiles\seatab\filson.zipalzip -a "D:\datafiles\tab\*.csv" "D:\datafiles\tab\Compress.zippackage runs fine manually and takes two minutes to complete.My probelm this DTS package when schedule as SQL JOb it hangs and run for ever. |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-04-01 : 12:29:44
|
| Is the user who owns the scheduled job the same as the user you're logged in as when you run the package manually? Also, try specifying the full path to alzip in the batch file. It's possible that the agent can't find the exe in its path. |
 |
|
|
|
|
|
DTS Executing .bat file in execute process task