@echo off
Echo.
Echo ...... XOS CLEAR LOCAL UPLOAD-DOWNLOAD QUEUE v1.0 ......
Echo.
Echo.
Echo NOTE: ....THIS MUST BE RUN WITH ADMIN RIGHTS....

timeout /t 2 /nobreak > NUL 
Echo.
Echo.
Echo.

echo USE AssetManagement >> "C:\DELETE UPLOAD-DOWNLOAD QUEUE.SQL"
echo DELETE FROM UPLOADQUEUE >> "C:\DELETE UPLOAD-DOWNLOAD QUEUE.SQL"
echo DELETE FROM DOWNLOADQUEUE >> "C:\DELETE UPLOAD-DOWNLOAD QUEUE.SQL"



sqlcmd -S localhost\coachingsolns  -U sa -P xostech  -i "C:\DELETE UPLOAD-DOWNLOAD QUEUE.SQL"


timeout /t 2 /nobreak > NUL 


DEL "C:\DELETE UPLOAD-DOWNLOAD QUEUE.SQL"


PAUSE