how to trap dos errorlevel when sqlcmd execution timout ?

• pierrejean

  SSC Rookie

  Points: 43

  More actions

  February 8, 2007 at 4:57 am

  #69588

  Hello,

  I test %ERRORLEVEL% in a .bat file who execute sqlcmd -b -l 1 -t 1 ...

  but sqlcmd exits with success (dos errorlevel = 0) when execution time out !!!

  I test with options -m-1 and -V1 but it doesn't work.

   

  any idea how to trap dos errorlevel when sqlcmd execution timout ?

   

  Thanks,

   

  --

• February 12, 2007 at 8:00 am

  This was removed by the editor as SPAM

• JohnnyDBA

  SSCertifiable

  Points: 6355

  More actions

  July 22, 2013 at 12:46 pm

  #1634642

  I realize this is very old, but this is still unanswered. Anyone know the solution to this?

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  August 21, 2013 at 2:26 pm

  #1643644

  Hi,

  Not tried it by myself but may be useful to you:

  sqlcmd <yourscript>

  IF ERRORLEVEL 1 goto err_handler

  goto done

  :err_handler

  REM handle the error here

  :done

  REM script completion code here

  Ref: http://stackoverflow.com/questions/5795430/error-handling-with-batch-file-sqlcmd