Oracle - job

-- JOB確認

set lin200

set pages 99

col INTERVAl format a20

col NEXT_DATE format a30

col WHAT format a60

ALTER SESSION SET NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss';

select JOB,LAST_DATE,THIS_DATE,NEXT_DATE,INTERVAl,WHAT,FAILURES,BROKEN FROM DBA_JOBS;

-- 実行中のJOB確認 DBA_JOBS_RUNNING

set lin100

set pages 99

ALTER SESSION SET NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss';

select SID,WHAT from DBA_JOBS_RUNNING a, DBA_JOBS b

WHERE a.JOB = b.JOB;

-- JOB実行

DBMS_JOB.RUN(ジョブ番号);