Oracle DBA Scheduler Jobs
-- Scheduled Jobs Listing

SELECT * FROM dba_scheduler_jobs
WHERE owner = UPPER('&i_owner')
AND   state = 'SCHEDULED'
;

-- Scheduler Running Jobs Listing

SELECT * FROM v$scheduler_running_jobs;

-- Scheduler Job Creation
BEGIN
 DBMS_SCHEDULER.create_job(
  job_name         => 'EDW.LOAD_STATUS_STAGING',
  job_type         => 'PLSQL_BLOCK',
  job_action       => 'BEGIN edw.hourly_refresh_stg; END;', 
  start_date       => SYSDATE,
  repeat_interval  => 'FREQ=MINUTELY;INTERVAL=15',
  enabled          => TRUE,
  comments         => 'Review data load status'
 );
END;
/

-- Scheduler Job Disabling
BEGIN  DBMS_SCHEDULER.disable('EDW.LOAD_STATUS_STAGING');
END;
/

-- Scheduler Job Enabling
BEGIN  DBMS_SCHEDULER.enable('EDW.LOAD_STATUS_STAGING');
END;
/

Oracle DBMS_SCHEDULER Jobs - Enable/Disable Using PL/SQL

Oracle registered trademark of Oracle Corporation.

Last Revised On: March 18th, 2012

  204