Exec Stored Procedure of SQL Server

[nelson.albarran]

Hi, I want to exec a stored procedure by alarm using automatic control, Is it possible?

• This topic was modified 4 years ago by Mikhail.

[Mikhail]

Hi,
Using Automatic Control Module you can send a command. KpDbImport driver helps to execute SQL according to the command.

[nelson.albarran]

How? I created a Output Channel, and i created the alarm in Automatic Control Module. What more i should do. Please, a quick guide.

[Mikhail]

Fist of all, configure KpDbImport driver. The approach is usual. Create a device, input and output channels. Make sure that when you send a command via Administrator’s UI, the driver executes SQL request.

You could provide screenshots of your KpDbImport settings if they don’t work.

[nelson.albarran]

I created the DbImport Device and I have communication with the data base, the query works. But I dont know how to exec the command, “exec my_sp”.

https://drive.google.com/open?id=1Lxf8O4YlVxKqWLpRQvc0mu6Mkl4gRrYH

[Mikhail]

The modern KpDbImport has the Commands tab to configure commands.
You should update Rapid SCADA to 5.8.x

[Author]

Posts