schedule task

Comments

• Options

  Brian Donahue Posts: 6,590 Bronze 1

  February 5, 2007 6:43AM

  Hi Bert,
  
  The easiest way would be to use the %ERRORLEVEL% variable in your script after you run the SQL Compare, to check the return code. If you type in SQLCOMPARE.exe /? /verbose | more, then you can see the list of all the return codes. You could handle all possible return codes differently, but at the simplest, your next line of script can be:

  IF %ERRORLEVEL% GTR 0 GOTO ERROR
  ERROR:
  REM Do Something
  

  0 · Share on Twitter