How to call the Stored Procedure in the Event using MySQL DB

Posted on Monday, 13 April 2020

SQL: How to call the Stored Procedure in the Event using MySQL DB

Description

In an even we can call a stored procedure and it can be scheduled for a specific time.

Syntax

The syntax in the SQL Server for the calling the stored procedure in a event is as following

First step:--



   ALTER EVENT job_example_Temp_Insert

   ENABLE;

2. Second step:--

ALTER EVENT job_example_Temp_Insert

ON SCHEDULE EVERY 1 hour

DO

CALL new_procedure();

0comments

Post a Comment