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”
