-
Bug
-
Resolution: Unresolved
-
Blocker
-
None
This has been assigned a sblocker because we have jenkins POC at ORG Level on wednesday and need to sort out before that
Trying to execute SQL query using windows power shell plugin which is working fine in cmd but when i paste the same in Jenkin Windows power shell plugin its displaying below eeror
SQLCMD -S DBINSTANCE -Q "Select Count from DBTABLE with (nolock);"
Started by user anonymous
Building in workspace C:\Program Files (x86)\Jenkins\jobs\WindowsPowerShell\workspace
[workspace] $ powershell.exe -NonInteractive -ExecutionPolicy ByPass "& 'C:\WINDOWS\TEMP\hudson4262101233229977039.ps1'"
The term 'SQLCMD' is not recognized as the name of a cmdlet, function, script f
ile, or operable program. Check the spelling of the name, or if a path was incl
uded, verify that the path is correct and try again.
At C:\WINDOWS\TEMP\hudson4262101233229977039.ps1:1 char:7
+ SQLCMD <<<< -S DBINSTANCE -Q "Select Count from DBTABLE with (nolock);"
+ CategoryInfo : ObjectNotFound: (SQLCMD:String) [], CommandNotFo
undException
+ FullyQualifiedErrorId : CommandNotFoundException