写存储过程
写job
运行job,如果不执行,则
查看顺序,好像顺序的值大于0就可以
SQL> show parameter job;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> alter system set job_queue_processes=11;
System altered
SQL> show parameter job;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 11
SQL>