https://community.blueprism.com/t5/Product-Forum/Using-SQL-to-update-the-target-resources/m-p/57128#M11190 ​Hello, we are trying to use a SQL statement to update the number of target resources in an active queue based on the number of items pending in a queue. Unfortunately we are able to update the number but it does not trigger the process to start in BP. The Target resources moves up then back to 0 after a moment with no processes being started. Has anyone had any success with this?<BR /><BR />------------------------------<BR />Cory Lavigne<BR />Staff Analyst<BR />Gap Inc.<BR />America/Denver<BR />------------------------------<BR /> Tue, 29 Oct 2019 17:33:00 GMT CoryLavigne 2019-10-29T17:33:00Z https://community.blueprism.com/t5/Product-Forum/Using-SQL-to-update-the-target-resources/m-p/57128#M11190 ​Hello, we are trying to use a SQL statement to update the number of target resources in an active queue based on the number of items pending in a queue. Unfortunately we are able to update the number but it does not trigger the process to start in BP. The Target resources moves up then back to 0 after a moment with no processes being started. Has anyone had any success with this?<BR /><BR />------------------------------<BR />Cory Lavigne<BR />Staff Analyst<BR />Gap Inc.<BR />America/Denver<BR />------------------------------<BR /> Tue, 29 Oct 2019 17:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Using-SQL-to-update-the-target-resources/m-p/57128#M11190 CoryLavigne 2019-10-29T17:33:00Z