Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE EVENT process_job_queue ON SCHEDULE EVERY 1 MINUTE DO BEGIN DECLARE done INT DEFAULT 0; -- Pick and lock next pending job UPDATE job_queue SET status = "processing", started_at = NOW(), worker = CONNECTION_ID() WHERE status = "pending" ORDER BY created_at LIMIT 1; -- Log processing attempt IF ROW_COUNT() > 0 THEN INSERT INTO event_audit (event_name, run_at) VALUES ("queue_processor", NOW()); END IF; END// DELIMITER ;
Result
Open