catch error

[vasblr]

Hi
I was new to MSDos, my question is i want to catch the error message to a variable\to a .txt file

Example:
i want to rename file which doesnot in the dir, DOS threw an error, i want to catch that error and its DOS error code in to variable

[macdad-]

Code: [Select]

if ERRORLEVEL 2
(
set return=%errorlevel%
)
Will this do?

[devcom]

Code: [Select]

dir ZX:\ 2>File.txt
for /f "tokens=1*" %%a in (File.txt) do echo %%a
pause
yes drive ZX will not exist just for example

[vasblr]

thank you for help !!! its working 

i want to catch all types of errors

here comes.. i am running a batch file script in batch file is a below
----------------------------------------------------------------------------------------------
REM Starts JOB (jobID 1)
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -S HDBLVTXDEAM4271-E -Q "EXEC Account.dbo.PROC_Fetch_Details_Start 1"
----------------------------------------------------------------------------------------------

i am running thru SQL server , here for first time job runs it was success (capture success) , in second run as the job was already running , it should thru error (capture the error message, append to the existing log file)

is it possible to capture all the error\success MSG in one log file??..

[vasblr]

i got the solution to catch the msg..  to a text file only on failure
----------------------------------------------------------------------------------------------
echo.-- %Date% %Time% -- >>c:\logfile.txt
REM Starts JOB (jobID 1)
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -S HDBLVTXDEAM4271-E -Q "EXEC Account.dbo.PROC_Fetch_Details_Start 1">>c:\logfile.txt
----------------------------------------------------------------------------------------------

small problem.. i can't catch the success of the batchfile as of now with the above statement i can catch only if there is any failure of the script\interalerrors
on scuccess log shows as below
------------------------------------------
-- Fri 03/06/2009 15:16:23.84 --
------------------------------------------

Please help me if i can capture success 

[macdad-]

if you want to capture success then try this:

Code: [Select]

if ERRORLEVEL==0
(
set return=%errorlevel%
)
that will capture it on success
and here's a complete list of all the errorlevel codes: http://www.computerhope.com/xdoseror.htm

[Reno]

are you sure sqlcmd.exe give some message when run successfully? try running sqlcmd.exe without redirecting it to file, and see if it gives message on success.

if it doesnt output message when success, you can manually echo it:

Code: [Select]

("C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -S HDBLVTXDEAM4271-E -Q "EXEC Account.dbo.PROC_Fetch_Details_Start 1" && echo sqlcmd.exe success)>>c:\logfile.txt 2>>&1

[vasblr]

Thanks all, for help.  , i got the required result.

[macdad-]

glad to hear it