@echo off REM MailDeliveryChk.cmd REM REM Written by David Cain REM Creates email of quantity of items in mail_delivery table REM Last edited 12-12-2016 DMC - New Server REM Updated SQL utilities REM 30-05-2017 DMC - Updated SQL utilities REM setlocal enableextensions REM set source=C:\Program Files\Microsoft SQL Server\80\Tools\Binn set source=C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn pushd "%source%" for /f "tokens=* delims= " %%a in ( 'sqlcmd.exe -U tbims -S BLTV-QSM -d VQSM -P tbims -Q "SELECT COUNT(*) FROM mail_delivery" ^| c:\autotask\grep1 [0-9][0-9]' ) do ( set myvar=%%a ) if "%myvar%" == "" set myvar=0 for %%a in (%myvar%) do set myvar=%%a REM echo/%%myvar%%=%myvar% popd REM pause %~dp0bmail.exe -s %mailsvr% -t %maillist% -f %mailsrc% -h -a "Mail_Delivery table has %myvar% records" -b "Mail_Delivery table has %myvar% records ( 0 is good! ) endlocal