scheduler 

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

posted @ 2013-07-17 00:31  ArcerZhang  阅读(196)  评论(0)  编辑  收藏  举报