use select query in the exit block, then the value would be avalaible for

%errolevel% variable

osql -E -SMSHSRMNSUKD0311 -Q "EXIT(Declare @asd smallint Exec test_db..usp_jobs_status @OutVal=@asd OUTPUT select

You can try using EXIT in the SQL file

EXIT(set nocount on

DECLARE @ReturnCode INT

Exec YourStoreProc @retstatus=@ReturnCode output

select ISNULL(@ReturnCode,7))

In the cmd / bat file after the osql

use %ERRORLEVEL% variable to get the...