How to run a scheduler job manually in Oracle

Trigger a Scheduler job immediately without waiting for its schedule, then check the run result.

This runs the job now. With use_current_session => FALSE it runs in the background under a job slave.

BEGIN
  DBMS_SCHEDULER.RUN_JOB(
    job_name            => '&&job_name',
    use_current_session => FALSE);
END;
/

-- Verify (read-only): latest run outcomes
SELECT * FROM (
  SELECT log_date, status, error#, run_duration
  FROM   dba_scheduler_job_run_details
  WHERE  job_name = UPPER('&job_name')
  ORDER  BY log_date DESC)
WHERE ROWNUM <= 5;