使用一个事件执行两个过程 [英] execute two procedure using one event

问题描述

CREATE EVENT EVENT_NOTIFICATION
ON SCHEDULE
EVERY 1 DAY STARTS '2013-10-15 15:42:00'
COMMENT 'Insert Notification'
DO CALL
sp_Notification();
SP_notificationStatus();

我想一个接一个地执行上面两个过程sp_Notification"和SP_notificationStatus"，但只有sp_Notification"过程在执行.

i want to execute above two procedure 'sp_Notification' and 'SP_notificationStatus' one after another but only 'sp_Notification' procedure is executing.

如何使用一个事件执行 2 个过程?

How to execute 2 procedure using one event?

推荐答案

我认为你想要这个:

CREATE EVENT EVENT_NOTIFICATION
ON SCHEDULE
EVERY 1 DAY STARTS '2013-10-15 15:42:00'
COMMENT 'Insert Notification'
DO CALL
sp_Notification();

CREATE EVENT EVENT_NOTIFICATION
ON SCHEDULE
EVERY 1 DAY STARTS '2013-10-15 15:42:00'
COMMENT 'Insert Notification'
DO CALL
SP_notificationStatus();

您也可以创建一个调用它们的新过程，然后安排一次.

You can also make a new procedure that calls both of them, then schedule that once.

这篇关于使用一个事件执行两个过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！