Command-line use of SQL Nexus

Jun 5, 2008 at 3:17 PM
Has anyone worked with command-line use of SQL Nexus?  I'm trying to automate a couple of server reports and keep gettin the mesage "The system could not find the file specified."  I've verified the paths I'm using (by cutting/pasting from my vbscript to the application UI), but it's still uncooperative.  Here's my script:

REM ==========================================================
REM Declaration Section
REM ==========================================================
REM --------------
REM -- Variables
dim runDate
dim cmdString
dim objShell
Dim Return
REM --------------
REM -- Constants
const server_name = """CORP-L-L3AZP91"""
const db_name     = "PARPerformance"
const import_path = """\\corp-par-001\pssdiag\output"""
const report_path = """\\corp-file-003\itcommon\dba\performance\PAR"""

REM ==========================================================
REM
REM ==========================================================

Set objShell = WScript.CreateObject("WScript.Shell")
Drive = "C:"

runDate =  Right("0" + CStr(year(date)),4) + Right("0" + CStr(Month(date)),2) + Right("0" + CStr(Day(date)),2)

 

cmdString = "sqlnexus /E" &_
               " /S" & server_name &_
               " /D" & db_name &_
               " /I" & import_path &_
               " /O" & report_path &_
               " /RReadtrace_Main" &_
               " /RUnique_Batch_TopN"

REM ==========================================================
REM
REM ==========================================================
WScript.Echo cmdString
Return = objShell.Run (cmdString, 2, true)

Coordinator
Sep 3, 2008 at 8:11 PM
Initial design had this in mind and it worked initially.   But due to time constratins, later enhancement and bug fixes didn't consdier this as a fator. so it's possible it may not work.
But since there is a demand, I have logged a work item to check on this.