Check if file exists in step in SQL
You can use a Powershell command on your job and raise an error if your file is not found so that your job will stop.
Something like:

if (-not (Test-Path $file)) 
{
    throw [System.IO.FileNotFoundException] "$file not found."
}