ObjFile.writeline("select value from v$parameter where name = 'log_archive_dest_2' and value is not null ") ObjFile.writeline("select value from v$parameter where name = 'log_archive_dest_1' and value is not null") ObjFile.writeline("select value from v$parameter where name = 'log_archive_dest' and value is not null") Set objFile = fso.CreateTextFile(TmpDir & "\s_" & DBNAME & ".sql", true)
WScript.Echo "Message: Unable to determine temp directory" If fso.folderexists(ServerName & "C$\WinNT\Temp") and TmpDirSet = False then If fso.folderexists(ServerName & "C$\Windows\Temp") and TmpDirSet = False then If fso.folderexists(ServerName & "C$\Temp") then ServerName = mid(Wscript.Arguments(0),1,EndofServer) Set WshShell = Wscript.CreateObject("WScript.Shell")ĮndofServer = instr(3,Wscript.Arguments(0),"\",0) Set fso = CreateObject("Scripting.FileSystemObject") I implemented WshShell.Remote with an error stating "unable to create ActiveX object"ĭim LOGIN, DBName, SQLSelect, TmpDir, TmpDirSet, ArchiveDrive, EndofServer, ServerName, SQLDirĭim WshShell, oExec, SQLOutput, fso, objfile, Disk, DiskFree, DiskTotal, DiskPercent I changed from WshShell.exec to WshShell.Run
#APPTIVATE API FREE#
When I manually create the output file, the script executes as expected calculating free space and etc. Permissions for the template credentials are domain and have access to the servers. I've opened a ticket with SW, but they referred me to the powershell doco and said they cant help with scripts, but I was really just asking how SW handles vbscript. I've tried capturing stderr and stdout from the vbscript, but they are always null. (creating script on poller and using wshremote to push to remote server and executing there) I've tried utilizing wshremote functions of vbscript without success. I've tried using the pipe symbol in the command I've tried changing around sqlplus command I've tried escaping various characters in the sqlcmd I've also tried setting up an ODBC for Oracle connection without success. I've tried turning off spool and using redirect to a file option as a part of the sqlcmd variable and the wshshell.exec parameters, neither of which work from SW, but all work locally. sql file just fine on remote system, but i dont think its executing the sqlplus command. sql command file on remote server with spool option. Summary : Given the server name and oracle instance name.ĭetermine temp directory, determine server name, create a. Is there something I'm missing with the way SW handles vbscripts? I used WshShell.exec and it didnt seem like it was running at all, I changed that to WshShell.Run and I get " Sqlplus has stopped responding. how it would run from the poller, works just fine as well.īut when executed from the SW poller, it seems as though there are issues. Running the vbs script locally, with UNC paths, i.e. Running the vbs script locally, with modifications for local paths, works just fine.
#APPTIVATE API WINDOWS#
I've created a vbscript monitor template that executes a sqlplus command on a remote windows server.
It preserved integral and tricky to communicate aspects of app design, sparked new ideas, and functioned as a kinetic pattern library for designers and developers working on iOS apps. captured fleeting transitions between app screens and delightful animated UI elements that we might otherwise have lost forever as apps and operating systems evolved.
0 kommentar(er)
