cancel
Showing results for 
Search instead for 
Did you mean: 

wanted to run a process using sql command

Vamshi_KrishnaD
Level 5
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.
------------------------------
VamshiKrihsna Dasa System Architect Fujitsu India Consulting Pvt. Ltd.
1 REPLY 1

james.man
Staff
Staff
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
------------------------------