查看JOB
select * from job_running_log s order by s.logon_time desc
select * from all_jobs
select * from JOB_SCHEDULE_TABLE
select * From dba_jobs_running
select * from dba_jobs --查看目前所有job
创建JOB:
DECLARE
jobNo1 NUMBER;
jobNo2 NUMBER;
BEGIN
DBMS_JOB.SUBMIT(job => jobNo1,
what => 'JOB_PACKAGE.padinfo_job_001;',
next_date => trunc(sysdate)+ 5/24,
interval => 'trunc(sysdate +1) + 5/24');
DBMS_JOB.SUBMIT(job => jobNo2,
what => 'JOB_PACKAGE.padinfo_job_002;',
next_date => trunc(sysdate)+2/24+30/1440,
interval => 'trunc(sysdate+1)+2/24+30/1440');
commit;
END;
/
--启用
begin
dbms_job.broken(8, false, sysdate);
commit;
end;
/
--禁用
begin
dbms_job.broken(8, true, sysdate);
commit;
end;
/