How can I configure the DSP to execute a PowerShell command on a DSP server?

DSP User

• November 18, 2016 12:53

I need to have DSP execute a PowerShell command on the DSP server. Does anyone know how to do this? I want to drive it by the click of a button and/or a Service page.

1

• 

  DSP Expert

  • November 18, 2016 13:33

  CBermingham:

  If you have permission to use xp_cmdshell, you can call the PowerShell script directly from a SQL Server stored procedure. Ensure that the DB process has the right to execute files wherever the script lives and to any other resources that the script uses.

  Here are 2 examples:

  • https://hubsqldba.wordpress.com/2013/07/31/call-a-powershell-ps1-file-from-a-stored-procedure/
  • http://stackoverflow.com/questions/38642066/how-to-execute-a-powershell-file-from-stored-procedure

  0
• 

  DSP Expert

  • November 18, 2016 13:34

  EWeldon: I’ve executed batch files in the past using the procedure: Cransoft..boaJobAddCommandTask

  0

Please sign in to leave a comment.