You are viewing limited content. For full access, please sign in.

Question

Question

Is there any option to call a SQL stored procedure from cloud workflow?

asked on May 7, 2021

When I go to create the rule, it only has these 3 options. With on-prem we can call a stored procedure, is this not an option in cloud?

0 0

Answer

SELECTED ANSWER
replied on May 7, 2021

You would have to write a script to connect to SQL and call the procedure.

0 0
replied on May 7, 2021

Does this mean write a C# script, run by the agent on the local host to run the procedure and return the data?

0 0
replied on May 7, 2021

Yes.

0 0
replied on May 7, 2021

Ok got it. So we can custom develop our our agent code, but no built in Stored Proc calls.

1 0
replied on March 25, 2022

Miruna, do you have any samples to perform this action? I need to call a procedure to perform some action and delete some records.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.