Thanks, Naoto. I made that change and will wait for the result.

>>Hi everybody,
>>
>>I'm trying to figure out why I am getting this error from SQL Server Agent job which is supposed to execute a batch file.
>>
>>End of the batch file is this:
>>
>>

>>IF NOT EXIST %Main_PATH%File_Extract\Status\File_Extract_Main%JobNbr%_OK.txt (
>>	REM powershell -NoProfile -ExecutionPolicy Bypass -Command "Write-EventLog -LogName 'VACCN' -Source 'DataRepo' -EventID 5120 -EntryType Error -Message 'Fatal error in VA Extract process.'"
>>	REM call %Main_PATH%EventWriterWriter\Scripts\release\EventWriter.exe %JobNbr% "DR_101" "batchfile" "Fatal error in VA Extract process."
>>	EXIT 11
>>)
>>ELSE (
>>	REM powershell -NoProfile -ExecutionPolicy Bypass -Command "Write-EventLog -LogName 'VACCN' -Source 'DataRepo' -EventID 5100 -EntryType Information -Message 'Successful completion of Extract Job 89.'"
>>	REM echo “Successful completion”
>>	EXIT
>>)

>>
>>The error in Agent is the following (end of the step):
>>
>>'ELSE' is not recognized as an internal or external command, operable program or batch file. Process Exit Code 9009. The step failed.
>>
>>Do you see what may be wrong with the bat file - it seems OK to me.
>
>Have you tried putting the ELSE on the same line as the closing parenthesis of the THEN part?
>

>IF ....  (
>    ...
>) ELSE (
>   ...
>)
>

>
>part of the help information if I type "if /?" on the command line in CMD.EXE
>

>...
>The ELSE clause must occur on the same line as the command after the IF.  For
>example:
>
>    IF EXIST filename. (
>        del filename.
>    ) ELSE (
>        echo filename. missing.
>    )
>
>The following would NOT work because the del command needs to be terminated
>by a newline:
>
>    IF EXIST filename. del filename. ELSE echo filename. missing
>
>Nor would the following work, since the ELSE command must be on the same line
>as the end of the IF command:
>
>    IF EXIST filename. del filename.
>    ELSE echo filename. missing
>
>The following would work if you want it all on one line:
>
>    IF EXIST filename. (del filename.) ELSE echo filename. missing
>...
>