Oracle 视图 ALL_SCHEDULER_JOB_CLASSES 官方解释,作用,如何使用详细说明
本站中文解释
视图
ALL_SCHEDULER_JOB_CLASSES视图提供Oracle数据库Scheduler中定义的任务类的信息,任务类可以被用来定义一批类似的任务。此视图有多个列,如:OWNER,JOB_CLASS_NAME,RESOURCE_PLAN,CREATION_DATE,UPDATE_DATE,SECURITY_GROUP,DESCRIPTION。
Oracle Scheduler使用视图ALL_SCHEDULER_JOB_CLASSES来查询,修改和创建任务类。
例如,要查询job_class_name列的所有条目,可以使用以下查询:
SELECT job_class_name FROM all_scheduler_job_classes;
官方英文解释
ALL_SCHEDULER_JOB_CLASSES
displays information about the Scheduler job classes accessible to the current user.
Related View
DBA_SCHEDULER_JOB_CLASSES
displays information about all Scheduler job classes in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the Scheduler job class |
|
|
|
Name of the Scheduler job class |
|
|
Resource consumer group associated with the class |
|
|
|
Name of the service the class is associated with |
|
|
|
Amount of logging that will be done pertaining to the class:
|
|
|
|
History (in days) to maintain in the job log for the class |
|
|
|
Comments on the class |
See Also:
“DBA_SCHEDULER_JOB_CLASSES”