Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2007-09-06 : 12:41:10
|
| This has got to be simple.I have a vbscript file that I can execute in a SQL job with the TSQL command: xp_cmdshell 'CScript //nologo C:\......\scriptname.vbs'and it works just fine. The "CScript" keeps the WScript.Echo commandfrom waiting for a response. It works marvellously.But I don't want my code out in a file somewhere. I want it in the jobstep.How do I do that?I tried calling it ActiveX Script and checking Visual Basic radio button. I Run it and get errors.Here is some simple code that I have been trying this with:WScript.Echo "Today is " & NowHere is the error I get:Error Source= Microsoft VBScript runtime error Error Description: Object required: 'WScript' Error on Line 1. The step failed.I know other people do this. Please help me out.Hayden |
|
|
|
|
|
VBScript in a SQL Job