Hcbb Script Auto Bat Site

:: Rebuild indexes for %%t in (Sales, Inventory, Customers) do ( %HCBB% sql --query "ALTER INDEX ALL ON %%t REBUILD" --server localhost if %errorlevel% neq 0 goto error )

@echo off :: HCBB Auto Batch Script - Production Ready :: Author: Admin :: Date: %date% %time% setlocal enabledelayedexpansion hcbb script auto bat

for /f "tokens=1-3 delims=/ " %%a in ('date /t') do set TODAY=%%a-%%b-%%c set OUTPUT_DIR=D:\HCBB_Output\%TODAY% if not exist "%OUTPUT_DIR%" mkdir "%OUTPUT_DIR%" Combine batch scripting with PowerShell to send alerts: :: Rebuild indexes for %%t in (Sales, Inventory,

:: Archive old logs %HCBB% archive --source C:\Logs --days 30 --destination E:\Archive if %errorlevel% neq 0 goto error hcbb script auto bat

:: ------------------- CLEANUP ------------------- forfiles /p "%OUTPUT_DIR%" /s /m *.tmp /d -7 /c "cmd /c del @file" echo [%date% %time%] Script finished. >> %LOG_FILE%