DBMS_SCHEDULER package
Use the package in a database reached through the Oracle-mode port.
Check a calendar expression
EVALUATE_CALENDAR_STRING returns a matching timestamp through its fourth argument. This example sets the session time zone to UTC. The expression matches every day at 09:30:00, so a search starting July 1 at noon returns July 2 at 09:30:00.
SET TIME ZONE 'UTC';
DECLARE
next_run TIMESTAMP WITH TIME ZONE;
BEGIN
DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING(
'FREQ=DAILY;BYHOUR=9;BYMINUTE=30;BYSECOND=0',
CAST('2026-01-01 00:00:00 +00:00' AS TIMESTAMP WITH TIME ZONE),
CAST('2026-07-01 12:00:00 +00:00' AS TIMESTAMP WITH TIME ZONE),
next_run);
RAISE NOTICE '%', next_run AT TIME ZONE 'UTC';
END;
/
RESET TIME ZONE;
Run a job once in the current session
This example creates a disabled job so it can be run on demand. RUN_JOB with use_current_session ⇒ TRUE runs synchronously and lets you inspect the effect before dropping the job. The query returns one row with ran.
CREATE TABLE scheduler_demo_log (message VARCHAR2(30));
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'scheduler_demo_job',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN INSERT INTO scheduler_demo_log VALUES (''ran''); END;',
enabled => FALSE,
auto_drop => FALSE);
DBMS_SCHEDULER.RUN_JOB('scheduler_demo_job', use_current_session => TRUE);
END;
/
SELECT message FROM scheduler_demo_log;
BEGIN
DBMS_SCHEDULER.DROP_JOB('scheduler_demo_job');
END;
/
DROP TABLE scheduler_demo_log;
For scheduled execution in the background, see DBMS_SCHEDULER implementation.