Schedule

sql>variable jobno number;
sql>begin
  2 sys.dbms_job.submit(:jobno, 'SP이름;', sysdate, 'TRUNC(SYSDATE) + 1', false);
  3 End;
  4 /

sql>print jobno
sql>exec dbms_job.run(21);
sql>commit;

잡실행여부확인
sql>col what format a20
sql>select what, job, next_date, next_sec, failures, broken from user_jobs;

잡강제실행
sql>exec dbms_job.run(21);
잡 Disable
sql>exec dbms_job.broken(21, true);
잡 삭제
sql>exec dbms_job.remove(21);