I do it with a Stored Procedure…. (Maria DB)
DELIMITER //
CREATE OR REPLACE PROCEDURE delay_seconds(p_seconds INT)
BEGIN
IF p_seconds IS NULL OR p_seconds < 0 THEN
SET p_seconds = 0;
ELSEIF p_seconds > 3600 THEN
SIGNAL SQLSTATE ‘45000’
SET MESSAGE_TEXT = ‘Sleep duration cannot exceed 3600 seconds (1 hour)’;
END IF;
DO SLEEP(p_seconds);
END //
DELIMITER ;
And test it in the DB like this…..
CALL delay_seconds(2);
Call it in Aware Process Like this…..
EXEC_SP ‘delay_seconds’ WITH ‘p_seconds’= 2