select owner, job_name , job_action , repeat_interval , state from
dba_scheduler_jobs where owner='MARRIOTTGROUPS_LIVE'; --------scheduler list
select owner, job_name , job_action , repeat_interval , state,next_run_date from
dba_scheduler_jobs where owner='PSA_LIVE' and JOB_ACTION in
('PRO_R_SER_SCHEDULAR','PRO_R_SER_SCED_MONTHLY');
select log_date , owner , job_name , status , req_start_date , ACTUAL_START_DATE ,
RUN_DURATION , ADDITIONAL_INFO from dba_scheduler_job_run_details
where owner='ONEX_PRODUCT_TRC' and job_name='LAPS_COMP_OFF' order by log_date
desc;-----LOG
exec dbms_scheduler.disable('HILTONGROUPS_LIVE.PROCESS_ACCRUAL'); ---for disable
scheduler
--jobname---
dbms_scheduler.STOP_JOB('ONEX_PRODUCT_SUNTECK.JOB_PROC_ATTEN_SCHEDULER');
exec dbms_scheduler.DISABLE('ONEX_PRODUCT_SUNTECK.JOB_PROC_ATTEN_SCHEDULER');
exec dbms_scheduler.drop_job('ONEX_PRODUCT_FITTJEE.JOB_PROC_UPD_RULEID'); ------
Drop Scheduler
begin -----------For Create scheduler
(Run on Schema User)
dbms_scheduler.create_job(
JOB_NAME => 'PROC_APP_STATUS',
JOB_TYPE => 'STORED_PROCEDURE',
START_DATE =>SYSDATE,
REPEAT_INTERVAL =>'FREQ=WEEKLY;BYDAY=MON;BYHOUR=23;BYMINUTE=00',
JOB_ACTION =>'PCKAPPLICATIONSTATUS.PROC_APP_STATUS',
ENABLED =>TRUE,
JOB_CLASS =>'DEFAULT_JOB_CLASS');
END;
Attribute to change time (connect to schema and RUN on SChema)
begin
dbms_scheduler.set_attribute(
name => 'JOB_NAME',
attribute => 'REPEAT_INTERVAL',
value => 'FREQ=WEEKLY;BYDAY=MON;BYHOUR=23;BYMINUTE=00'
);
END;