create job
BEGIN
DBMS_SCHEDULER.CREATE_JOB(job_name => ' delete_goods_job ' ,
job_type => ' STORED_PROCEDURE ' ,
job_action => ' delete_goods ' ,
repeat_interval => ' FREQ=SECONDLY; INTERVAL=6 ' ,
enabled => true,
comments => ' delete goods data '
);
END ;
/
DBMS_SCHEDULER.CREATE_JOB(job_name => ' delete_goods_job ' ,
job_type => ' STORED_PROCEDURE ' ,
job_action => ' delete_goods ' ,
repeat_interval => ' FREQ=SECONDLY; INTERVAL=6 ' ,
enabled => true,
comments => ' delete goods data '
);
END ;
/
drop job
BEGIN
DBMS_SCHEDULER.DROP_JOB(job_name => ' delete_goods_job ' );
END ;
/
DBMS_SCHEDULER.DROP_JOB(job_name => ' delete_goods_job ' );
END ;
/
disable job
BEGIN
DBMS_SCHEDULER.DISABLE(name => ' delete_goods_job ' );
END ;
/
DBMS_SCHEDULER.DISABLE(name => ' delete_goods_job ' );
END ;
/
enable job
BEGIN
DBMS_SCHEDULER.ENABLE(name => ' delete_goods_job ' );
END ;
/
DBMS_SCHEDULER.ENABLE(name => ' delete_goods_job ' );
END ;
/
select jobs
select
*
from
USER_SCHEDULER_JOBS;
query logs(感谢itpub的teddyboy)
select
*
from
ALL_SCHEDULER_JOB_RUN_DETAILS
where owner = ' SCOTT '
order by log_date desc
where owner = ' SCOTT '
order by log_date desc
delete logs
delete
from
ALL_SCHEDULER_JOB_RUN_DETAILS
where owner = ' SCOTT '
where owner = ' SCOTT '