Oracle dbms_scheduler examples with procedure

Create Schedule:
BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => 'XXJAI_UPDATE_TAX_VERSION',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN XXJAI_PO_PKG; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=Secondly;',
    enabled         => TRUE);
END;

Drop Schedule:

BEGIN
  DBMS_SCHEDULER.drop_job (job_name => 'XXJAI_UPDATE_TAX_VERSION');
end;

Run Schedule Immediately:


begin
dbms_scheduler.run_job (job_name => 'run_load_sales');
end;

Repeat_Interval  with freq:

Yearly
Monthly
Weekly
Daily
Hourly
Minutely
Secondly

Example:

repeat_interval => 'freq=daily;byhour=22;byminute=30;bysecond=0'
repeat_interval => 'FREQ=MINUTELY;INTERVAL=1'
 repeat_interval => 'FREQ=DAILY;BYHOUR=1;BYMINUTE=0'
 repeat_interval => 'FREQ=MINUTELY;INTERVAL=3'

we can find schedule custom jobs by below query:
SELECT owner, job_name, enabled FROM dba_scheduler_jobs Where JOB_NAME like 'XX%