schedule task

EliBert

Hi Y'all,

What's the best way to check wheter a comparison at night (scheduled tasks in a batch file) was succesfull or not?

Thanks in advance!
Bert

Brian Donahue

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