-- 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; /
52895