Skip to main content
March 24, 2023
Question

Is there a way to execute a Create Trigger SQL script from a process?

  • March 24, 2023
  • 0 replies
  • 0 views

Hi,

I have a scheduled process that executes multiple SQL scripts.
The final of these scripts recreates triggers dropped in the first script.

Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service.


Is there another way this can be executed from the process model?

Thanks