⏰ Scheduler & Jobs
DBMS_SCHEDULER jobs: create, run, monitor and drop.
| Snippet | |
|---|---|
| ☆Create Job — Daily job that gathers stats at 2 AM |
BEGIN DBMS_SCHEDULER.CREATE_JOB(job_name => 'nightly_stats', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(''HR''); END;', start_date => SYSTIMESTAMP, repeat_interval => 'FREQ=DAILY;BYHOUR=2', enabled => TRUE); END;
|
| ☆Run Job Now — Trigger a job immediately |
EXEC DBMS_SCHEDULER.RUN_JOB('nightly_stats');
|
| ☆Enable / Disable — Toggle a job without dropping it |
EXEC DBMS_SCHEDULER.ENABLE('nightly_stats'); -- or DISABLE
|
| ☆Drop Job — Remove a scheduled job |
EXEC DBMS_SCHEDULER.DROP_JOB('nightly_stats');
|
| ☆Job Run History — Recent executions and their results |
SELECT job_name, status, actual_start_date, run_duration FROM user_scheduler_job_run_details ORDER BY actual_start_date DESC FETCH FIRST 20 ROWS ONLY;
|