title: Azure Webjob Powershell Error Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized
body: <p>Azure WebJobs run Powershell scripts, but Invoke-Sqlcmd fails in WebJob. How to fix?
  Script works in PowerShell ISE locally but fails in Azure Webjob:</p>
  
  <pre><code>    $result = Invoke-Sqlcmd -Query 'SELECT AlertLine FROM HR.AlertRecordsOpenInline;' `
      -ServerInstance 'xxxxxxxx.database.windows.net' `
      -Username 'xxxxx@xxxxxx' -Password 'xxxxxx' -Database 'xxxxxx'
  foreach($item in $result){
      [string]$Results += ($item.AlertLine)
      }
  $Results
  </code></pre>
  
  <p>WebJob Run Details Output:</p>
  
  <pre><code>[09/02/2016 16:09:00 &gt; da15b0: SYS INFO] Status changed to Initializing
  [09/02/2016 16:09:00 &gt; da15b0: SYS INFO] Run script 'Invoke-Sqlcmd.ps1' with script host - 'PowerShellScriptHost'
  [09/02/2016 16:09:00 &gt; da15b0: SYS INFO] Status changed to Running
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a 
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] cmdlet, function, script file, or operable program. Check the spelling of the 
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] name, or if a path was included, verify that the path is correct and try again.
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] At D:\local\Temp\jobs\triggered\Invoke-Sqlcmd\ni4ywn1l.sgn\Invoke-Sqlcmd.ps1:1 
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] char:11
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] + $result = Invoke-Sqlcmd -Query 'SELECT AlertLine FROM 
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] HR.AlertRecordsOpenInline; ...
  [09/02/2016 16:09:01 &gt; da15b0: ERR ] +           ~~~~~~~~~~~~~
  [09/02/2016 16:09:01 &gt; da15b0: ERR ]     + CategoryInfo          : ObjectNotFound: (Invoke-Sqlcmd:String) [], Comma 
  [09/02/2016 16:09:01 &gt; da15b0: ERR ]    ndNotFoundException
  [09/02/2016 16:09:01 &gt; da15b0: ERR ]     + FullyQualifiedErrorId : CommandNotFoundException
  [09/02/2016 16:09:01 &gt; da15b0: ERR ]  
  [09/02/2016 16:09:01 &gt; da15b0: SYS INFO] Status changed to Success
  </code></pre>
  
  <p>Have searched and searched but am stuck, not sure what to try next. Thank you in advance for your help!</p>