Menu

1 / 2

Managing the Event Scheduler in GBase 8a

DEV Community·Michael·6 months ago
#HJYqmoK5
#via#gbase#database#software#event_scheduler
Reading 0:00
15s threshold

The event scheduler ( event_scheduler ) is the built‑in daemon thread in GBase 8a that runs timed events — think of it as your cron inside the database. It's on by default, and you must have it enabled if you plan to create any scheduled tasks. Here's how to check, start, and stop it in your gbase database.

Checking the Scheduler Status

SHOW VARIABLES LIKE '%event_scheduler%' ;

Enter fullscreen mode

Exit fullscreen mode

If the output shows ON , the scheduler is active and monitoring events.

Enabling the Event Scheduler

Via SQL

SET GLOBAL event_scheduler = ON ; -- or using the session variable syntax SET @@ global .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.