Hello, I'm trying to run a sas program using vbscript. I'm running vbscript on command prompt using cscript.exe Below is my vbscript code, where I'm just having "abcdefg" in sas program (to test). Currently I'm testing this to get error message on command prompt, but instead there is no error displayed on command prompt. I can see error message in the log though. Option Explicit Dim app Dim str Dim prjObject1 Dim fso str = "abcdefg" Call dowork(str)   'shut down the app If not (app Is Nothing) Then app.Quit Set app = Nothing End If   Sub dowork(codestr) On Error Resume Next '---- ' Start up Enterprise Guide using the project name '---- Dim prjName Dim prjObject Set app = CreateObject("SASEGObjectModel.Application.7.1") If Checkerror("CreateObject") = True Then Exit Sub End If Set prjObject = app.New Set fso = CreateObject("Scripting.FileSystemObject") Set prjObject1 = prjObject.CodeCollection.Add prjObject1.GenListing = True prjObject1.GenSasReport = True prjObject1.Text = codestr '----- ' run the project '----- prjObject1.run If Checkerror("Code.run") = True Then Exit Sub End If ' Save the log file to LOCAL disk prjObject1.Log.SaveAs(Wscript.ScriptName & ".log") End Sub Function Checkerror(fnName) Checkerror = False Dim strmsg Dim errNum If Err.Number <> 0 Then strmsg = "Error #" & Hex(Err.Number) & vbCrLf & "In Function " & fnName & vbCrLf & Err.Description MsgBox strmsg 'Uncomment this line if you want to be notified via MessageBox of Errors in the script. wscript.echo(strmsg) wscript.quit(4) Checkerror = True End If End Function   ERROR MESSAGE IN LOG: abcdefg ERROR 180-322: Statement is not valid or it is used out of proper order. Is there any way to have this error returned in command prompt ? Any help is really appreciated. Thank You.   ... View more

I've been trying to automate a vbs script (generated by Enterprise Guide 7.1) using Jenkins and am not able to troubleshoot the error. I've read many similar post here on sas community and have tried all the solutions that were suggested, but still having the issue. Please find the detailed explanation of the error below:   I'm trying to run the below script using Jenkins' Windows batch execution : %windir%\System32\cscript.exe "~dir\EGScript1.vbs" and I'm getting the error: Microsoft (R) Windows Script Host Version 5.812 Copyright (C) Microsoft Corporation. All rights reserved. ~dir\EGScript1.vbs(7, 1) Microsoft VBScript runtime error: Object required     The vbs script works perfectly using command prompt and even with windows task scheduler.   After investigation, I found out that the issue is in creating this object Set app = CreateObject("SASEGObjectModel.Application.7.1"). For testing purpose I verified the line-- Set app = CreateObject("excel.application") which works perfectly fine (even in Jenkins). I've tried all the options that were suggested including the links below: https://communities.sas.com/t5/SAS-Enterprise-Guide/schedule-task-in-sas-eg/td-p/212052 https://communities.sas.com/t5/SAS-Enterprise-Guide/VBScript-error-could-not-locate-automation-class/td-p/103212   I'm using 64 bit machine and my EG is also 64 bit. I've also tried to run the below statement, but still getting the error of SASEGObjectModel.Application.7.1 using Jenkins. C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm /codebase /tlb "C:\Program Files\SASHome\SASEnterpriseGuide\7.1\SASEGScripting.dll" Please suggest and let me know if anymore info is required.   Thanks in advance. ... View more