osql from batch file

• Jonathan Matt

  SSCarpal Tunnel

  Points: 4027

  More actions

  May 14, 2004 at 12:02 pm

  #161484

  Hello all,

  I am running the following osql from a Windows 2000 cmd batch file:

  osql -E -S %2 -d msdb -n -Q -i C:\JobStatus\%3\JobStatus.sql -b

  if not %errorlevel% 0 (echo An error has occured creating stored procedures!) & (goto :Exit)

  echo Stored procedures created.

  JobStatus.sql is a script file that creats stored procedures in the msdb.

  If the SQL Server is stopped, I would like to exit the script here, but I cannot seem to capture anything from osql to test in the script to see if it was able to connect or not.  I just get a "Server does not exist" message, that I think comes from ODBC and the script continues to execute.

  Any thoughts?

  Thanks

  Jonathan

   

   

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  May 15, 2004 at 9:29 am

  #506567

  crude but effective?

  for /F %%a in ('osql -S%2 -h-1 -n -E -Q"set nocount on select 1"') do if not "%%a"=="1" goto :Exit

  echo can connect

  :Exit