scheduler

最新推荐文章于 2024-12-05 09:39:18 发布

weixin_30828379

最新推荐文章于 2024-12-05 09:39:18 发布

阅读量58

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/arcer/p/3194736.html

SQL> col start_date for a40
SQL> col end_date for a40
SQL> select schedule_name,start_date,end_date,comments from user_scheduler_schedules;

SCHEDULE_NAME                  START_DATE                               END_DATE                                 COMMENTS
------------------------------ ---------------------------------------- ---------------------------------------- ----------------------------------------
SCHEDULE_INVEST                30-MAY-13 10.56.52.153951 PM +08:00      29-JUN-13 10.56.52.000000 PM +08:00      Every Minutely
SCHEDULE_INVEST_20110630       02-JUN-13 12.17.09.858085 PM +08:00      02-JUL-13 12.17.09.000000 PM +08:00      Every Minutely

SQL>

查看scheduler

SQL> col program_action for a50
SQL> select program_name,program_type,program_action from user_scheduler_programs;

PROGRAM_NAME                   PROGRAM_TYPE     PROGRAM_ACTION
------------------------------ ---------------- --------------------------------------------------
INVEST_PROGRAM                 STORED_PROCEDURE ARCER.AUTO_INSERT_INVEST_DATA_PROC
INVEST_PROGRAM_20110630        STORED_PROCEDURE ARCER.AUTO_INST_INVEST_DATA_20110630

SQL>

查看program

SQL> select job_name from user_scheduler_jobs;

no rows selected

View Code

参考文章:

http://friendlysong.blog.163.com/blog/static/3225243920117775416827/

http://www.cnblogs.com/lanzi/archive/2012/11/23/2784815.html

转载于:https://www.cnblogs.com/arcer/p/3194736.html