Solved

Executing stored procedures with a scheduled proces flow


Userlevel 5
Badge +20

I am still looking for a method to schedule stored procedures in a process flow and expected this in the 2021.2 release.

There doesn't seem to be any process action for this yet. But, could it be realized by using a 'dummy' HTTP connector (eg GET: www.nos.nl) or by using a Decision? 

 

 

… and then calling the desired stored procedure within the process procedure, like below:

create procedure prc_pf_send_notifications_pf_execute_stored_procedure
(
@dummy text_100 output
)

as
begin

-- Do not count affected rows for performance
SET NOCOUNT ON;


--control_proc_id: process_pf_send_notifications
--template_id: process_pf_send_notifications
--prog_object_item_id: process_pf_send_notifications
--template_description:

EXEC dbo.any_stored_procedure

end
go

 

Or is there a more elegant way?

 

Related post:

 

icon

Best answer by Mark Jongeling 19 May 2021, 12:36

View original

2 replies

Userlevel 7
Badge +23

Hi Harm,

There is currently no other way to execute stored procedure besides either using the Decision node, DB connector, Application connector or HTTP connector (with Indicium). In SQL code you can indeed execute the stored procedure. So the way you are implementing this now is currently the best way.

For the 2021.3 we are working on a way to execute Tasks in System flows using a new process action.

Userlevel 5
Badge +20

Mark,

OK, great :thumbsup_tone1:

I will try this, it is very simple to implement this way and will do exactly what I need.

Reply