Scripted CMD & Sql Function 
Author Message
 Scripted CMD & Sql Function

Hi;

I am quite new to WSH I hope someone can shed some light, or direct me to
some resources
to answer my question.

What I need to be able to do is register the success or failure of a CMD
file be executed.
I need to be able to modify a record in a database with either success or
failure.
I am not sure if the application I am calling can return any type of
indicator for success or failure.

Right now I would be happy with just modifying the record after the CMD file
runs.  The key word
here is after so the database will be accurate in saying the operation has
completed.

Thanx in advance.

M



Mon, 16 Sep 2002 03:00:00 GMT  
 Scripted CMD & Sql Function
WshShell Object
http://msdn.microsoft.com/scripting/windowshost/doc/wsObjWshShellM.htm

Run Method
http://msdn.microsoft.com/scripting/windowshost/doc/wsMthRun.htm

set Shell = createobject("wscript.shell")
exitcode = Shell.Run("yourcommand",0,True)

--
Michael Harris
MVP Scripting

Hi;

I am quite new to WSH I hope someone can shed some light, or direct me to
some resources
to answer my question.

What I need to be able to do is register the success or failure of a CMD
file be executed.
I need to be able to modify a record in a database with either success or
failure.
I am not sure if the application I am calling can return any type of
indicator for success or failure.

Right now I would be happy with just modifying the record after the CMD file
runs.  The key word
here is after so the database will be accurate in saying the operation has
completed.

Thanx in advance.

M



Tue, 17 Sep 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Running SQL through VBS in CMD.

2. Using Vbscript and SQL-DMO to connect to SQL Server and run a T-SQL script

3. Running SQL through VBS in CMD.

4. Scripted functions within Access SQL ??

5. Is it possible to get filename of .CMD filename that is being executed by CMD.EXE _FROM_ inside the .CMD script?

6. Is it possible to get filename of .CMD filename that is being executed by CMD.EXE _FROM_ inside the .CMD script?

7. Need to turn this .cmd file from an NT server into a VB Script Please Help

8. CMD usage in scripts

9. Opening cmd with script

10. JScript, pIE, PocketPC & SQL Server CE

11. SQL & Textbox Object

12. SQL Server & password

 

 
Powered by phpBB® Forum Software