@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