创建job
----定义 JOB
declare
job number;
begin
sys.dbms_job.submit(job,'P_DBP_SYS_LOG_AUDIT_BEGIN;',to_date('2012-1-18 4:30:00','yyyy-mm-dd hh24:mi:ss'),'sysdate+1');
end;

---- 查看job
SELECT * FROM user_jobs


---- 删除job
DECLARE
BEGIN
sys.dbms_job.remove(524);
COMMIT;
END;

----- 修改job 下次执行时间

DECLARE
BEGIN
sys.dbms_job.next_date(564,to_date('2012-1-18 5:30:00','yyyy-mm-dd hh24:mi:ss'));
COMMIT;
END;