Oracle 一旦作业完成，DBMS_SCHEDULER程序不会自动丢弃

SQL> create or replace
  2  procedure my_proc is
  3  begin
  4    null;
  5  end;
  6  /

Procedure created.

SQL>
SQL> begin
  2    dbms_scheduler.create_program (
  3      program_name   => 'MY_PROGRAM',
  4      program_type   => 'PLSQL_BLOCK',
  5      program_action => 'begin my_proc; end;',
  6      enabled        => true);
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> begin
  2    DBMS_SCHEDULER.create_job (
  3      job_name      => 'MY_JOB',
  4      program_name  => 'MY_PROGRAM',
  5      start_date      => SYSTIMESTAMP,
  6      enabled       => TRUE);
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL> select job_name
  2  from dba_scheduler_jobs
  3  where owner = user;

no rows selected  -- ie, it has been run

SQL>
SQL> select program_name
  2  from dba_scheduler_programs
  3  where owner = user;

PROGRAM_NAME
--------------------------------------------------------------------------------------------------------------------------------
MY_PROGRAM

1 row selected.

SQL>
SQL>