JOB_QUEUE_PROCESSES Parameter Change

In 11g Release 2, both DBMS_JOB and DBMS_SCHEDULER share the same job queue coordinator, so the value of the JOB_QUEUE_PROECESSES parameter affects both schedulers for the first time. If the value is set to 0, both schedulers will be disabled. If the value is set to non-zero, both schedulers will be enabled.

run_job
BEGIN
   dbms_scheduler.run_job(job_name => 'hr.job1');
END;

stop_job
BEGIN dbms_scheduler.stop_job(job_name => 'hr.job1');END;

copy_job
BEGIN dbms_scheduler.copy_job(old_job =>'hr.job1' ,new_job =>'hr.job11' );END;

drop_job
BEGIN dbms_scheduler.drop_job(job_name => 'hr.job11');END;

select * from  V$SCHEDULER_RUNNING_JOBS;

dbms_scheduler包一些视图
--*代表all或dba或user
--1.查看job的视图
*_scheduler_jobs --查看job
*_scheduler_job_args  --查看job的所有输入参数
*_scheduler_job_classes --查看job的类信息
*_scheduler_job_dests --查看job状态
*_scheduler_job_log --查看job日志
*_scheduler_job_run_details --查看job执行的详细信息
all_scheduler_running_jobs

--2.查看chain的一些视图
*_scheduler_chains
*_scheduler_chain_rules
*_scheduler_chain_steps
*_scheduler_running_chains --查看正在执行的chains

--3.查看program的视图
*_scheduler_programs --查看程序
*_scheduler_program_args --查看程序参数

--4.查看调度组信息
*_scheduler_groups
*_scheduler_group_members

--5.查看window的视图（这类视图只有dba和all开头的）
*_scheduler_windows --查看window
*_scheduler_window_details --查看window详细信息
*_scheduler_window_groups --查看window组
*_scheduler_window_log --查看window日志
*_scheduler_wingroup_members ----查看window成员

--6.查看scheduler视图
*_scheduler_schedules --查看调度
*_scheduler_global_attribute --显示所有的调度属性
*_scheduler_credentials
*_scheduler_db_dests
*_scheduler_dests
*_scheduler_external_dests
*_scheduler_file_watchers
*_scheduler_notifications
*_scheduler_remote_databases
*_scheduler_remote_jobstate
