Oracle 从触发器调用计划程序

SQL> create table t (
  2    x int
  3  );

Table created.

SQL>
SQL> create or replace trigger trig
  2    after insert on t
  3  declare
  4    pragma autonomous_transaction;
  5  begin
  6
  7    dbms_scheduler.create_job (
  8      job_name        => 'test_job',
  9      job_type        => 'PLSQL_BLOCK',
 10      job_action      => 'begin null end;',
 11      start_date      => systimestamp,
 12      repeat_interval => 'freq=daily;',
 13      enabled         => true);
 14
 15  end;
 16  /

Trigger created.

SQL>
SQL> insert into t values (1);

1 row created.

SQL>
SQL> select job_name from user_scheduler_jobs;

JOB_NAME
------------------------------
TEST_JOB

SQL> rollback;

Rollback complete.

SQL>
SQL> select * from t;

no rows selected

SQL>
SQL> select job_name from user_scheduler_jobs;

JOB_NAME
------------------------------
TEST_JOB