Skip to main content
Solved

Executing stored procedures with a scheduled proces flow


Harm Horstman
Superhero
Forum|alt.badge.img+21

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:

https://community.thinkwisesoftware.com/questions-conversations-78/how-to-schedule-a-process-flow-1240

 

Best answer by Mark Jongeling

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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3945 replies
  • Answer
  • May 19, 2021

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.


Harm Horstman
Superhero
Forum|alt.badge.img+21

Mark,

OK, great :thumbsup_tone1:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings