Exec Stored Procedure of SQL Server

Forum Home Forums Understanding the Software Exec Stored Procedure of SQL Server

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #6720
    Avatarnelson.albarran
    Participant

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

    • This topic was modified 3 months ago by MikhailMikhail.
    #6724
    MikhailMikhail
    Moderator

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

    #6725
    Avatarnelson.albarran
    Participant

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

    #6726
    MikhailMikhail
    Moderator

    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.

    #6729
    Avatarnelson.albarran
    Participant

    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

    #6738
    MikhailMikhail
    Moderator

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

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.