SQL> select job,log_user,priv_user,last_date,next_date,interval from user_jobs; JOB LOG_USERLAST_DATENEXT_DATEINTERVAL ---------- ----------------------------------- ------------------------------ ----------- 22 PERFSTAT 2002-12-5:14:33:26 2002-12-5 14:43:00 trunc(SYSDATE+1/144,'MI') SQL> execute dbms_job.remove('22') PL/SQL procedure successfully completed |
欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/) | Powered by Discuz! X3.2 |