CmdExec jobstep hangs

• Gary Cobden

  Ten Centuries

  Points: 1269

  More actions

  June 14, 2005 at 3:56 am

  #167376

  Hi

  I have a job running the following CmdExec statement/batch file which works fine on other databases; however, in this particular instance, the job just stalls on this jobstep. The CmdExec jobstep statement is:-

  -----

  "e:\program files\microsoft sql server\mssql\backup\zipmove_test.bat"

  -----

  And the zipmove_test.bat file is as follows:-

  -----

  e:

  cd "\Program Files\Microsoft SQL Server\mssql\backup"

  del DATIXTS_TEST.ZIP

  "c:\program files\winzip\wzzip.exe" DATIXTST northwind.bak pubs.bak master_full.bak msdb_full.bak model_full.bak

  move DATIXTST.zip DATIXTS_TEST.ZIP

  -----

  The jobstep gets as far as the del DATIXTS_TEST.ZIP command, but then does no more, and just stalls, without failing. Run interactively at a Command Prompt, the batch file executes fine, creating the ZIP file without any problems.

  Any assistance please

  Thanks

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  June 14, 2005 at 4:15 am

  #565208

  It sounds to me as if the del command is waiting for a response from your batch.