wanted to run a process using sql command

Vamshi_KrishnaD — Wed, 09 Sep 2020 18:55:00 GMT

Hi Team

I wan to run a process from SQL management studio

can i know the procedure.

and i need an document what all the possibilities can do it from SQL

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

RE: wanted to run a process using sql command

james.man — Thu, 10 Sep 2020 07:24:00 GMT

If you want to trigger Blue Prism from within SSMS, you will need to first enable xp_cmdshell:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-ver15

After enabling xp_cmdshell, you can trigger processes to run from Blue Prism's command line interface (if you somehow have access to the Runtime Resources from your SSMS installation), or HTTP interface. Some documentation about this is here:
https://bpdocs.blueprism.com/bp-6-9/en-us/helpHTTPInterface.htm
https://bpdocs.blueprism.com/bp-6-9/en-us/helpCommandLine.htm?tocpath=Interface%7CAdvanced%20options%7C_____2

Alternatively, you could design the process such that it is exposed as a SOAPXML web service, and then call the SOAP XML web service from a script (such as Python) that is called from the CLI through xp_cmdshell.

Unfortunately, no documentation exists to help you with this as it is quite custom and not something that customers normally do with Blue Prism.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

topic wanted to run a process using sql command in Product Forum

wanted to run a process using sql command

RE: wanted to run a process using sql command