![Batch Script Waiting File Monitor](http://purplewells.com/wp-content/uploads/2023/07/language-school-illustration-05-800x675.png)
Batch Script Waiting File Monitor
The file monitor batch script is purposefully designed to wait for files in a folder before subsequent downstream processes are started. This is useful in integration applications where there are dependencies on such files or resources to be present before those processes ca n be initialised.
Rem Desc : This script when activated waits for files in a folder to be present. When the specified is available it then proceeds to start a SQL Agent job to kick subsequent processes.
@echo off
setlocal enabledelayedexpansion
:: Set variables
set "folderPath=\\bhxappfs01\InhouseApps\UAT\Blue Yonder\Outbound" REM Path to the folder to monitor
set "ssisJobName=Dashboard_CostPriceDeltaOutput" REM Name of the SQL Server Agent job
:: File patterns to look for
set "patterns=PMM_DB_IB01_ PMM_DB_IB02_ PMM_DB_ADJ_ PMM_DB_BR02_"
:loop
:: Initialize an array to keep track of found files
set "foundFiles="
:: Loop through the file patterns and find the most recent files
for %%P in (%patterns%) do (
set "mostRecentFile="
for /f "delims=" %%F in ('dir /b /o-d "%folderPath%\%%P" 2^>nul') do (
if not defined mostRecentFile (
set "mostRecentFile=%%F"
set "foundFiles=!foundFiles! %%F"
)
)
)
:: Check if all four files are found and output their filenames and extensions
for %%P in (%patterns%) do (
echo Looking for %%P...
if not "!foundFiles: %%P=!"=="" (
set "filename="
for %%F in (!foundFiles: %%P=!) do (
set "filename=%%~nF"
set "extension=%%~xF"
echo %%P found: !filename!!extension!
)
) else (
echo %%P not found. Waiting for all files...
goto continueWaiting
)
)
:: All four files are found; trigger the SSIS job
echo All required files found. Triggering the SSIS job...
sqlcmd -S YOUR_SERVERNAME -Q "EXEC msdb.dbo.sp_start_job @job_name = '%ssisJobName%'"
:continueWaiting
:: Pause for a specified time (e.g., 5 minutes)
timeout /t 300 >nul
goto loop
</pre>